1 Reply Latest reply on Apr 18, 2015 6:40 AM by philmodjunk

    How to exclude all duplicates but one?

    SimonOuellet

      Title

      How to exclude all duplicates but one?

      Post

      I have a table with many activities for each person (on another table). I want to sort those activities for each semester (3 months period). I want to have a calculation that would give me the number of semesters each person has been working. My problem is probably simple but i just can't figure out how to have a search that would find the person (unique number) and only one of each semester.

      How can i eliminate all duplicates but one of each?

      Thanks