Using the Advanced Filter retains one of the matching (duplicate) rows. I
want to eliminate both of these rows keeping only the new (truly unique) data
that do not match any other data.

Any suggestions?

"smw226 via OfficeKB.com" wrote:

Hi GMK,

Highlight your data then Dataadvance Filter

check "Unique Records only" then hit OK

HTH

SImon

GMK wrote:
I have two multicolumn lists that contain a great amount of duplicate data. I
want to extract only rows that do not match any other row. Is there a
"simple" way to do this?

Thanks.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1