Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Searching for repeated numbers in the same column
In the future, put your question in the body of the message, please. We
cannot respond to empty messages (title only). Assume your numbers are in column A, from row 2 down to row 1044 In any available column, put this formula on row 2: =CountIf($A$2:$A$1044,A2) and fill the formula down to row 1044. It will show a value of 1 where the number in column A is unique to the list, it will show a value greater than 1 where multiple occurrences of the number on that row appear in the list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search for repeated numbers in same column | New Users to Excel | |||
repeated numbers or value | Excel Worksheet Functions | |||
how to delete repeated numbers in a column, make it apears once | Excel Discussion (Misc queries) | |||
Column with repeated numbers | Excel Worksheet Functions | |||
how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) |