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?
User | Count |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |