Spreadsheet: 745747d1630160640-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-data-validation
Sheet: 1522 (an)

Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column Excel Magic Trick 1522
Office 365: New Excel Calculation Engine with Dynamic Array Functions and Spilling, Dynamic Arrays
Date | Revenue | Customer | Region | SalesRep | Product
2018-10-17 00:00:00 | 1215.7 | Google | West | Sioux | Quad
2018-10-17 00:00:00 | 731.81 | Amazon | East | Chantel | Carlota
2018-10-17 00:00:00 | 376.13 | Google | West | Chantel | Quad
2018-10-17 00:00:00 | 300.09 | Microsoft | West | Sioux | Carlota
2018-10-17 00:00:00 | 884.05 | Microsoft | West | [NAME] | Yanaki
2018-10-17 00:00:00 | 615.42 | Amazon | East | [NAME] | Carlota
2018-10-17 00:00:00 | 1185.25 | Amazon | East | Chantel | Quad
2018-10-17 00:00:00 | 2548 | Google | West | Timmy | Yanaki
2018-10-17 00:00:00 | 415.25 | Microsoft | East | [NAME] | Quad
2018-10-20 00:00:00 | 15870.25 | Microsoft | East | Chantel | Yanaki
2018-10-20 00:00:00 | 254.96 | Amazon | West | Timmy | Carlota
2018-10-20 00:00:00 | 2015.3 | Google | East | Timmy | Quad
2018-10-20 00:00:00 | 1459.78 | Microsoft | West | Chantel | Aspen
2018-10-20 00:00:00 | 815.17 | Amazon | East | Sioux | Aspen
2018-10-20 00:00:00 | 1686.99 | Google | West | [NAME] | Aspen
2018-10-20 00:00:00 | 757 | Microsoft | East | Chantel | Aspen
2018-10-20 00:00:00 | 618.24 | Amazon | East | Sioux | Yanaki
2018-10-20 00:00:00 | 1136.81 | Google | West | [NAME] | Aspen
2018-10-20 00:00:00 | 1944.45 | Google | East | Timmy | Quad
2018-10-20 00:00:00 | 523.25 | Microsoft | West | Timmy | Aspen
2018-10-21 00:00:00 | 634.7 | Google | West | Yio | Aspen
2018-10-21 00:00:00 | 704.94 | [NAME] | East | Min | Aspen
2018-10-21 00:00:00 | 1017.05 | [NAME] | West | Min | Carlota
2018-10-21 00:00:00 | 1166.13 | [NAME] | East | Min | Quad
2018-10-21 00:00:00 | 548.36 | [NAME] | East | Yio | Quad
2018-10-21 00:00:00 | 411.05 | [NAME] | West | Min | Yanaki
2018-10-21 00:00:00 | 486.53 | [NAME] | West | Yio | Yanaki
2018-10-21 00:00:00 | 1914.13 | [NAME] | East | Min | Aspen
2018-10-21 00:00:00 | 2262.16 | Amazon | West | Yio | Yanaki
2018-10-21 00:00:00 | 609.25 | Google | East | Min | Aspen
2018-10-21 00:00:00 | 1969.03 | Microsoft | East | Yio | Sunset
2018-10-21 00:00:00 | 634.7 | Google | West | Yio | Aspen
2018-10-21 00:00:00 | 704.94 | [NAME] | East | Min | Aspen
2018-10-21 00:00:00 | 1017.05 | [NAME] | West | Min | Carlota
2018-10-21 00:00:00 | 1166.13 | [NAME] | East | Min | Quad
2018-10-21 00:00:00 | 548.36 | [NAME] | East | Yio | Quad
2018-10-21 00:00:00 | 411.05 | [NAME] | West | Min | Yanaki
2018-10-21 00:00:00 | 486.53 | [NAME] | West | Yio | Yanaki
2018-10-21 00:00:00 | 1914.13 | [NAME] | East | Min | Aspen
2018-10-21 00:00:00 | 2262.16 | Amazon | West | Yio | Yanaki
2018-10-21 00:00:00 | 609.25 | Google | East | Min | Aspen
2018-10-21 00:00:00 | 1969.03 | Microsoft | West | Yio | Sunset
2018-10-22 00:00:00 | 1301.11 | [NAME] | East | [NAME] | Sunset
2018-10-22 00:00:00 | 1687.42 | [NAME] | West | Sioux | Sunset
2018-10-22 00:00:00 | 192.85 | [NAME] | East | Timmy | Sunset
2018-10-22 00:00:00 | 447.5 | Amazon | West | Min | Sunset
2018-10-22 00:00:00 | 834.89 | Google | East | Min | Sunset
2018-10-22 00:00:00 | 2033.97 | Microsoft | West | Min | Sunset
2018-10-22 00:00:00 | 1757.7 | [NAME] | East | Chantel | Sunset
2018-10-22 00:00:00 | 169.25 | [NAME] | West | Chantel | Sunset
2018-10-22 00:00:00 | 548 | Google | East | Min | Carlota
2018-10-22 00:00:00 | 2459.35 | Google | West | Yio | Carlota