Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I need two macros to do as follows: ONE I need a macro which will check every row in a worksheet and if it finds two or more duplicate rows (i.e. every cell in the row is duplicated), it will then proceed to delete all duplicate rows except the first duplicate row. TWO I need a macro which will check every row in a worksheet and if it finds two or more rows with the exact same value in a particular column, it will then proceed to delete all duplicate rows except the first duplicate row. I would prefer the user to have the ability to specify the column they want interrogated. Any suggestions would be greatly appreciated! Thanks, Joe. -- If you can measure it, you can improve it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing rows | Excel Programming | |||
comparing rows | Excel Programming | |||
Comparing rows | Excel Programming | |||
comparing two rows, then highting? | Links and Linking in Excel | |||
Comparing two rows | Excel Programming |