Idetnifying repeats in a column

J

JRD

Can anyone help?

If I have a column of 10 digit numbers, is there a function which can
identify when a number is repeated

e.g.

A B
1 Number Repeat?
2 1234567890 Yes
3 2345678901 No
4 3456789012 No
5 1234567890 Yes
6 4567890123 No


So I need a function entered in column B which searches down the entire
column A to look for an identical number and if it finds one, it puts in
"Yes" and if not it puts in "No"

Thanks

John
 

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

Unique #s in column, need multiple associated numbers in columns 5
function for finding repeats in a column... 2
Complex function needed? 5
How to check previous entries in column for same contents 4
Formula (or code) return the largest number of duplicates in a list. 16
column A matches f places the value from g in column b what funct 2
dismiss blanks in lookup 5
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top