• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

COUNT unique value for each day

Pioneer

New Member
Hello,
I have uploaded the work book.
I need some help in counting the number of unique/different staff i met throughout that day.
e.g. From the attached workbook, on 14th I made 7 visits but i met only 4 different unique staff.
on 17th I made 8 total visits but met only 3 different people, i want a value 3 for 17th

Can someone help with a formula to calculate the number of unique staff i met on one day.

THank you.
 

Attachments

  • staff visited.xls
    26.5 KB · Views: 2
Thank you Narayank991 for a quick reply. I will check the previous posts before asking a question next time.
 
Back
Top