Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for numbers duplication
Pls provide a macro code when finds the numbers which are repeated in a range
of cell. Rgds lino. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for numbers duplication
Use conditional formatting with a formula of
=COUNTIF(A:A,A1)1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lino" wrote in message ... Pls provide a macro code when finds the numbers which are repeated in a range of cell. Rgds lino. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to check duplication of id numbers | Excel Worksheet Functions | |||
perventing duplication of numbers on a spreadsheet | Excel Discussion (Misc queries) | |||
How to sort out all numbers without duplication? | Excel Discussion (Misc queries) | |||
How to sort out a list of numbers without duplication? | Excel Discussion (Misc queries) | |||
How do I prevent duplication of numbers in a column | Excel Discussion (Misc queries) |