Count how many different cells are in a range

J

John T Kennedy

I need a formula/filter/something to help me out.

I have:

Column D: Last Name
Column E: First Name
Column F: Company
Column G: Address Line 1
Column H: Address Line 2
etc...

I know my list has many many duplicate records, and I need now how to get
rid of the duplicates and count those left. If a record shows up at least
once, I need it to count, but I don't want to count the numerous duplicates
in my spreadsheet.

Thanks for helping.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top