Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |