Unique records

[Miranda]

I would like to filter two separate lists in order to end
up with only a list of unique records...the only formula
that I have found so far, leaves me with the number of
unique records, when what I want to know what is actually
unique in the list.

any help is greatly appreciated.

Miranda

 

[Paul]

I would like to filter two separate lists in order to end
up with only a list of unique records...the only formula
that I have found so far, leaves me with the number of
unique records, when what I want to know what is actually
unique in the list.

any help is greatly appreciated.

Miranda

You may find something here to help you:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique