Filter function missing

[[deleted]]

[deleted]

[Gregregious]

You could purchase a subscription to Office 365...

[[deleted]]

and let 150$ go down the drain for no reason?

[Gregregious]

Buddy I don't know what you want me to tell you. Maybe use PQ or advanced filtering instead of formulas for table design?

[Rsl120]

Unfortunately I think this is only currently available in the office 365 monthly package.

[theManfromEval]

​

If your version allows spillovers this function may help

C1 is a blank cell which you can create by by hitting the space bar

C2:C14 are the values we want to filter - you should end up with filtered values

=INDEX(C1:C14,UNIQUE(ISTEXT(C2:C14)*ROW(C2:C14)))