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.
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.