Most valuable professional
  • Hot Topics

Excel count unique for each

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

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of March 31, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel