Hi- I have a huge data file and was looking to get some help in calculating the number of distinct values in excel. I have three columns A B & C and column C has Names of people and Column A has which projects they have worked on and Column B has their team names.
I would like to have a formula with which i can find out, in how many projects each person has worked on. I have attached a sample data which is very minimal (the actual data has around 10000 line items). I would be grateful for any suggestions.
Thanks!
Arun
I would like to have a formula with which i can find out, in how many projects each person has worked on. I have attached a sample data which is very minimal (the actual data has around 10000 line items). I would be grateful for any suggestions.
Thanks!
Arun