Hello
I'm trying to create a list of unique values from a field in a large Table based upon multiple criteria that works in Excel 2010 (i.e. without dynamic array functions).
The following works is how I can do it Excel 365, but I'm struggling to get the same results without using the FILTER and UNIQUE functions:
In the above Target_Ref_Diag_Comm_days refers to a single cell named range that is a whole number
I've been looking at posts using INDEX SMALL and ROWS, but can't get my head round how to apply them.
Very grateful for some help!
I'm trying to create a list of unique values from a field in a large Table based upon multiple criteria that works in Excel 2010 (i.e. without dynamic array functions).
The following works is how I can do it Excel 365, but I'm struggling to get the same results without using the FILTER and UNIQUE functions:
Excel Formula:
=SORT(UNIQUE(FILTER(tbl_Events[Referral Reference],
(tbl_Events[Event]="Communication")*
(tbl_Events[Days to Diagnosis communication from recent referral]>=0)*
(tbl_Events[Days to Diagnosis communication from recent referral]<=Target_Ref_Diag_Comm_days)*
(tbl_Events[Clinic]=Report_Clinic),"No results"),FALSE))
In the above Target_Ref_Diag_Comm_days refers to a single cell named range that is a whole number
I've been looking at posts using INDEX SMALL and ROWS, but can't get my head round how to apply them.
Very grateful for some help!