Forum Discussion
Solved
Does Filter(Unique()) work on tables?
Hi, I think the array formulas are great but I can't get the filter function to work on table columns. For example - if I do =Filter(Unique(Table1[Column1]), Table1[Column1]="ABC") I just get...
Dazzathedrummer You need to place UNIQUE outside the FILTER function.
Something like this:
=UNIQUE(FILTER(Table1[Column1], Table1[Column2]="123"))
The count of the items is not equal.
Check:
=COUNTA(Unique(Table1[Column1]))
=COUNTA(Table1[Column1]="ABC")