How to match and sort
 

Hi, I was wondering if there was a function or simple program to match
and sort two colums. Let's say the first column is a list compiled by
person A and the second is a list compiled by person B. So what I need
done is to match the ones they have in common and filter out the ones
that are different.

For example, let say we're comparing names and birthdays:

Birthday (A)Name (A)Name (B) Birthday (B)
6/14 Josh Josephine 3/16
2/15 Chris Sharon 9/4
9/4 Sharon Jerry 8/11
2/28 Lillian Susan 7/12
8/11 Jerry

I want it so that when I compare the two lists, it would become:

Birthday (A)Name (A)Name (B) Birthday (B)
9/4 Sharon Sharon 9/4
8/11 Jerry Jerry 8/11

2/28 Lillian
6/14 Josh
2/15 Chris
Josephine 3/16
Susan 7/12

I guess what I want to do is to delete the similar rows and keep the
dissimilar rows. Is there an easy way of doing this?


--
lakegoddess
------------------------------------------------------------------------
lakegoddess's Profile: http://www.excelforum.com/member.php...o&userid=18646
View this thread: http://www.excelforum.com/showthread...hreadid=484913