Posted to microsoft.public.excel.programming

Papa Jonah Papa Jonah is offline

external usenet poster

Posts: 148

comparing rows

Is there a macro that can be used to compare a row to the row above resulting
in a highlight if it is a duplicate?
What I need is to identify rows that are cell for cell duplicates - meaning
that if EVERY cell in the row is identical to the one above.

TIA
Papa

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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	[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 rows and deletion	sreedhar[_8_]	Excel Programming	11	October 11th 05 02:57 AM
Comparing rows in three sheets	wing	Excel Programming	0	April 30th 04 05:07 PM
Comparing two rows	mika.[_2_]	Excel Programming	1	December 17th 03 06:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us