Capture the unique values based on a name change in another column

[rogihead]

I have a sheet in which column C has names and column E has dates and the data is sorted alphabetically by column C. So the names, if duplicates are one right after each other. It is possible that in column C the same name would be listed multiple times and the dates in Column E may change. What I would like to try and figure out is for each name in Column C how many unique dates are there for that person and capture those date values into other columns. Not even sure where to begin with countif or what?

 

[C Moore]

Copy to second sheet, then use remove duplicates based only on the name. That way you have all your data safe, and manipulated data separate. If there was the same name with three dates, it would keep only the top name and date.

 

[rogihead]

I have found another way to accomplish what I need using a pivot table and some formulas.

Thank you for your reply.