Forum Discussion
Index removing duplicates
Check this. I think FILTER and UNIQUE does work
=UNIQUE(FILTER(Table1[Activity template hk],Table1[Suggested Staff hk]=C5,"None found"))That's the formula I entered and it seemed to me at any rate that it produces the result you are looking for. I've attached the revised spreadsheet.
This first performs a FILTERing of the activity column based on the staff ID
Then the UNIQUE eliminates duplicates.
Thanks for the reply, I have watch this and unfortunatley does not given me what I am really wanting (maybe it's impossible :)).
I have attached a mock up of part of the spreadsheet shwowing where and what I am trying to do - if this is still not clear please let me know.
I just need the activity to show once for the relevant staff member
Thanks again for all help
Check this. I think FILTER and UNIQUE does work
=UNIQUE(FILTER(Table1[Activity template hk],Table1[Suggested Staff hk]=C5,"None found"))
That's the formula I entered and it seemed to me at any rate that it produces the result you are looking for. I've attached the revised spreadsheet.
This first performs a FILTERing of the activity column based on the staff ID
Then the UNIQUE eliminates duplicates.
Hi Both
Many thanks for the replies, both work perfectly
Apologies I couldn't get the Unique/Filter to work but I now have a better understanding of it.
Thanks again