How to find duplicates within same column

F

Frank Beltre

Hello all,

I am trying to find if there are any duplicate values within the same
column, without removing them. Example

ID no.
1121
2222
3343
5554
6785
4565
6785
1121
3343

In this example 1121, 3343, 6785 are duplicates. I have a ~20000 rows
spreadsheet and would like to speed up the process.

Thank you all,

Frank
 

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

MS Excel Function (Find Duplicate values) 3
Deleting Duplicate Data in a Column. 7
Augmenting an integer in a column to reflect duplicates in another 23
flagging duplicates within same column of data 5
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
finding duplicate addresses across 2 worksheets in the same workbo 2
How to find duplicate column (not the cell values) 3
Finding/Removing Duplicate Numbers In A Column ? 4

Top