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 #VALUE!
Am I getting the formula wrong or does Filter() not work on tables?
Being able to filter on associated table columns would be great - =Filter(Unique(Table1[Column1]), Table1[Column2]="123")
Dazzathedrummer You need to place UNIQUE outside the FILTER function.
Something like this:
=UNIQUE(FILTER(Table1[Column1], Table1[Column2]="123"))
3 Replies
The count of the items is not equal.
Check:
=COUNTA(Unique(Table1[Column1])) =COUNTA(Table1[Column1]="ABC")Dazzathedrummer You need to place UNIQUE outside the FILTER function.
Something like this:
=UNIQUE(FILTER(Table1[Column1], Table1[Column2]="123"))- That's fixed it!
It seems so obvious when you see it - thanks!
