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.

A few steps:

1)Sort the spreadsheet by Name
2)Insert a column and write an IF formula, see attached spreadsheet.
3)If you see ??????????? then there is a duplicate (NOTE: the 1st duplicate does not have the ?????????)

Attached Files

Book1.xlsx (8.7 KB, 6 views)

OK... I can do that. But I don't understand why I have to go to that much trouble. In older versions of excel, I could create a pivot table that would just count the number of times something occurred in a field. It could be accomplished in just a couple of mouse clicks, and it didn't matter how the data was sorted. I probably can still do that, but the handy little dialog boxes that used to step you through the pivot table set up don't pop up anymore.

You could write a pivot table.

See attached.

Attached Files

Book1.xlsx (11.6 KB, 7 views)

I guess that's what I'm trying to do, but the process is different now than it was in the older versions of excel. There used to be a "pivot table wizard" that stepped you through the process. If it's still available, I can't find it.

What version of excel are you using?

I have Office 365

Use the attached link, it is actually pretty easy now to create pivot tables

https://support.office.com/en-us/art...9-c842dcdd2869

Hope this helps.

To open the old wizard perhaps Alt+D - P

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you... I'll do that.