How do I identify duplicate numbers in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel sheet with 4 columns and over 700 rows
Columns:
1 ID number
2 First name
3 Last name
4 Location

My concern is the ID number. Is there any function, without scrolling
through the entire list, that I can use to identify Duplicate numbers?
 
You must log in or register to reply here.

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

Similar Threads

duplicate numbers in a column 2
Identify Duplicates in a List 1
Identify Duplicates that are not identical 4
Duplicate data 2
script or format to identify duplicate data 2
counting identical items in a column and returning the occurrences 3
Identifying duplicate rows 2
Removing Duplicates to another sheet 1

Back
Top