How do I find duplicate numbers in a data?

M

Manni

Hi,

I have a data I'm working with and I want to create a formula to tell me if
the number I am working on is a duplicate in that same data. Can someone
please help?

Thanks.
 
S

Sheeloo

Assuming you have your numbers in Col A from row 1 to row 20 then
Enter this in B1 and copy till B20
=COUNTIF($A$1:$A$20,A1)

Duplicate numbers will have a count of 2 or more against them.
 

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

Repeated phrases wildcard? 1
Finding Duplicate Rows & Highlighting them 6
Removing a repeated words 0
You don't currently have permission to access this folder 0
Autonumber field in Excel that behaves the same as Access 0
how to do data validation in excel 1
Duplicate entry in a column/row 14
How to sync OL365 contacts and calendar to iPhone without iTunes? 1

Top