excel 2010
I need to count the unique ProjectName (column B) for each ProjectID (column A) and enter it in column C
i.e. MD has 1 unique name, BW has 2 unique names...
.........A...........B..........C
1......MD.......McDan.....1
2......MD.......McDan.....1
3......BW.......Bill..........2
4......AF........Alf...........1
5......BW.......Billie........2
I need to count the unique ProjectName (column B) for each ProjectID (column A) and enter it in column C
i.e. MD has 1 unique name, BW has 2 unique names...
.........A...........B..........C
1......MD.......McDan.....1
2......MD.......McDan.....1
3......BW.......Bill..........2
4......AF........Alf...........1
5......BW.......Billie........2