Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding/Removing Duplicate Numbers In A Column ?
Hi,
I have a long list of numbers in a column. How would I determine if there are duplicates, and "flag" them ? How would I remove all the duplicates in a single, perhaps, step ? Thanks, B. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Finding/Removing Duplicate Numbers In A Column ?
See
http://cpearson.com/excel/duplicat.htm In article , "Robert11" wrote: Hi, I have a long list of numbers in a column. How would I determine if there are duplicates, and "flag" them ? How would I remove all the duplicates in a single, perhaps, step ? Thanks, B. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
From OP: Problems Running It ?. Finding/Removing Duplicate Numbers In A Column ?
Hello again,
Thank you very much for help. Appreciate it. Can't seem to get it to work, undoubtedly because I'm doing something really dumb with this. Relatively new user. Would just like to highlight any and all duplicates. Have my mumbers in Col B, from row 2 to row 483 Entered: changed to Formula Is. =if(countif($B$2:$B$483,B2)1, true,false) When trying to run it, I get an error msg. that says: You may not use unions, intersections, or array constants for conditional formatting criteria. Any idea what I might be doing wrong ? Thanks again, Bob -------------------------------- "JE McGimpsey" wrote in message ... See http://cpearson.com/excel/duplicat.htm In article , "Robert11" wrote: Hi, I have a long list of numbers in a column. How would I determine if there are duplicates, and "flag" them ? How would I remove all the duplicates in a single, perhaps, step ? Thanks, B. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
From OP: Got It To Work !: Finding/Removing Duplicate Numbers In A Column ?
Hi All,
Much thanks to everyone for all the help. Got it to work now ! Bob --------------------- "Robert11" wrote in message ... Hi, I have a long list of numbers in a column. How would I determine if there are duplicates, and "flag" them ? How would I remove all the duplicates in a single, perhaps, step ? Thanks, B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Match Column B numbers to Column A numbers | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
How do I prevent duplicate numbers from being entered in a column. | Excel Discussion (Misc queries) |