I've a simple table as below but with a lot of data. I need to get the numbers of staff per category using an excel formula while making sure I dont count duplicate entries.
Total number of category V should be 2 . Using CountifI get 3 which is wrong (as v10 appears twice, it must be considered only once)( COUNTIF(F4:F10,"V")
How do I define the second criteria - of ignoring multiple occurences of staffid and using just the first ?
ThanksS. No StaffID Name Category
1 Nil P1 R
2 v81 P2 V
3 v10 P3 V
4 s71 P4 S
5 b47 P5 B
6 b62 P6 B
7 v10 P3 V
A
Bookmarks