I have a list with two columns. Column names are Username and Status (options Free and Busy).
Usernames can have both Free and Busy status or only one type Free or Busy.

To make more clear this is example:

    Username     |  Status
    ------------------------
    Peter Parker |    Busy
    Peter Parker |    Free
    Hal Jordan    |    Free
    Clark Kent    |    Busy
    Clark Kent    |    Free


Now I need a view to show only Hal Jordan as he is only one with unique status.
I know to do this with two WFs, one comparing usernames (in another list where are just usernames) for each item and then triggering another WF to update hidden column in next item so first WF can check that item next and so on, but it takes a year to complete and it needs to be refreshed on item created/changed.

Do you have any idea how to do this on easy way?
(exp. Like in excel when you can filter columns)

• Edited by DannyNS Monday, August 03, 2015 7:36 AM

Hi,

Based on your description, you want to show the items that only have unique values of username column in SharePoint 2013.

If you want an easy way to achieve it, you could add custom code in the event receiver in the list.  When the item is added or updated, it will check if there are duplicate items. You could create a flag column in the list, and the default value is 1. If there is duplicate items, update the value of the flag column to 2. You could modify the view, filter the value of the flag column is 1.

The article below is about creating a simple Event Receiver in SharePoint 2013.

http://onceinawhilescribble.blogspot.com/2013/05/creating-simple-event-receiver-in.html

The article below is about checking duplicate item before adding to List using Event Receivers.

https://prasadgavande.wordpress.com/2015/04/11/check-duplicate-item-before-adding-to-list-using-event-receivers/

Best regards,

Sara Fan

Thank you Sara. I will try your suggestion.

EDIT:

I am not allowed to use visual studio at all. Thank you.

• Edited by DannyNS 1 hour 0 minutes ago