ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for numbers duplication (https://www.excelbanter.com/excel-programming/402561-macro-numbers-duplication.html)

Lino

Macro for numbers duplication
 
Pls provide a macro code when finds the numbers which are repeated in a range
of cell.


Rgds
lino.

Bob Phillips

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.





All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com