You can join up all test conditions then delete
or concatenate them into say column E then compare

like if A(i)=A(i-1) and B(i)=B(i-1) and C(i)=C(i-1) and D(i)=D(i-1) then
row(i).delete

or E=A & B & C & D
compare E and delete as desire

"luu980" wrote:


Does anyone know of a macro to remove identical rows in excel?

That is, the macro is to first *_compare_rows_against_one_another_*
then delete the identical ones, leaving only one copy.

I have found many macros that delete rows, but it only compares values
in a single column. This is NOT what I need.

What I need is this, for example:

aaaa bbbb cccc dddd
aaaa bbbb zzzzz dddd
aaaa rrrrrr cccc dddd
mmm bbbb cccc dddd
aaaa bbbb cccc dddd
aaaa bbbb zzzzz dddd
aaaa bbbb zzzzz dddd

Leaving me:
aaaa bbbb cccc dddd
aaaa bbbb zzzzz dddd
aaaa rrrrrr cccc dddd
mmm bbbb cccc dddd


--
luu980
------------------------------------------------------------------------
luu980's Profile: http://www.excelforum.com/member.php...fo&userid=6931
View this thread: http://www.excelforum.com/showthread...hreadid=520376