repeated values

S

sood

I have 16 coulmns and 239 rows containing telephone numbers. I want to know
whether there are repeated telephone numbers in a column or row.
 
A

Allllen

In a blank cell outside your data use:

=IF(MAX(COUNTIF($A$1:$J$10,$A$1:$J$10))=1,"no","yes")
submit it using ctrl+shift+enter rather than just enter.

This tells you if the data has got repeated values (yes) or not (no).
 

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

COMMON NUMBERS 2
repeated numbers or value 2
Cross referencing data in Excel 4
Auto Formatting 3
table formula 19
how to check if any repeated values 3
Help converting a 10 digit number 2223334444 to 222-333-4444 2
lookup values vertically in a list and return the repeats 1

Top