Forum Discussion
UNIQUE function on table with filters
I have a table (fed from SQL). where the table filters are used to select data by date range. My issue is that using the UNIQUE function on the table data does not appear to take account the table f...
WillSmyth See attached. If that's not what you want, I don't know. Note that I filtered the table to show only items from 2023.
By the way, better to place the SORT(UNIQUE(FILTER(....))) formula in another sheet to avoid it from being hidden in case the filter hides the top rows of the sheet.
Riny_van_Eekelen
I have added the new column FILTERED with the formula =AGGREGATE(2,3,[@[TX_DATE]])
The FILTERED column displays value 0 regardless of the filter set on the table.
I have added the new column FILTERED with the formula =AGGREGATE(2,3,[@[TX_DATE]])
The FILTERED column displays value 0 regardless of the filter set on the table.
I think I have resolved the =AGGREGATE(2,3,[@[TX_DATE]]) formula with all visible rows showing . (assuming hidden rows will be a 0)
However entering the formula in L2 does not appear to work. Would you be able to give example in provided worksheet. Thanks
However entering the formula in L2 does not appear to work. Would you be able to give example in provided worksheet. Thanks
WillSmyth But the formula in L2 seems to work for me.
