Counting Occurance using Pivot Table
This used to be easy to do, but now I can't figure it out. I have a field in an excel worksheet that combines two fields... First & Last Name. I want to see how many duplicates I have, but all I seem to be able to find is "remove" duplicates. I don't want to remove them, I just want to see what's there.
Any advice will be greatly appreciated.
Thank you.
|