Thread: Comparing Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Monomeeth Monomeeth is offline
external usenet poster
 
Posts: 63
Default Comparing Rows

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!