Forum Discussion
Help with Index Match formula
Column D (4) or E (5) ?
Try a formula like this, using the field names from the table
=SORT(UNIQUE(FILTER(Table2[ColumnD], (Table2[ColumnY]<=E3)*(Table2[ColumnZ]>=E3))))
Thanks, I managed to work it out in the end. I did it in two steps producing an intermediary array which will be helpful to check certain data before the final list is created.
Turns out because of the wider dataset I didn't really need to filter by date as the data I wanted in terms of year to end was already in a particularly column (X) so X being greater than one, was the only bit of filtering I needed. Main List is the name of the workbook with the data in, its also a table, but this referencing seemed to work fine.
=SORT(FILTER(FILTER('Main List'!A:AE,'Main List'!X:X>1,),{1,0,0,0,1,0,1,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0}),7,-1)
=UNIQUE(SORT(C7:C100))
C7 being the start of the list I wanted unique values for sorted alphabetically.
Thanks!