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"))
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!
