Unique values after filtering

Hi All

I am trying to remove certain values and then whatever left after that, only return the unique values in the data. I have managed to get the filter correct using:

AND(IN([Status],LIST(Authorised,Draft)),isnotblank([Person]))

but then get stuck on the unique portion of whats left. So it currently returns 3 authorised with the same persons name, I only need one.

Any ideas?

0 7 683
7 REPLIES 7
Top Labels in this Space