The #NAME? but I have 1 difference: my equivalent of col A and 'order' is implemented in an excel 'table'. I want to get unique detail for this 3 columns in another cell as it has to be linked to the date range.. Hello! At the heart of the formula, the FILTER function filters out duplicate entries based on the count of occurrences, returned by the COUNTIF function. So, be sure you always have enough empty cells down and/or to the right of the cell where you enter the formula, otherwise a, The results update automatically when the source data changes. Select the “List range”. To fix the error, just clear or delete non-empty cells. Hello! UNIQUE is a new function available in Excel 365 only. How to convert a column number (e.g. To see the formula in action, let's get a list of unique winners for the sport in G1 (criteria 1) and under the age in G2 (criteria 2). It is only available in Excel 365. Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. It works with any data type: text, numbers, dates, times, etc. Or you can clearly inform your users that no results are found: =IFERROR(UNIQUE(FILTER(A2:B10, (C2:C10=G1) * (D2:D10