| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
repeated values
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeated values
In a blank cell outside your data use:
=IF(MAX(COUNTIF($A$1:$J$10,$A$1:$J$10))=1,"no","ye s") submit it using ctrl+shift+enter rather than just enter. This tells you if the data has got repeated values (yes) or not (no). -- Allllen "sood" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 10 with Repeated Values | Excel Discussion (Misc queries) | |||
| how can i know that my worksheet having repeated same values | Excel Worksheet Functions | |||
| Repeated values in a row | Excel Discussion (Misc queries) | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Hiding repeated values | Excel Discussion (Misc queries) | |||
Linear Mode
