LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing rows Papa Jonah Excel Programming 4 August 8th 08 01:26 AM
comparing rows [email protected][_2_] Excel Programming 2 June 12th 06 06:04 PM
Comparing rows praveen_khm[_36_] Excel Programming 3 March 24th 06 04:19 PM
comparing two rows, then highting? johnh Links and Linking in Excel 2 November 18th 05 09:29 AM
Comparing two rows mika.[_2_] Excel Programming 1 December 17th 03 06:27 PM


All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"