L
lakegoddess
Hi, I was wondering if there was a function or simple program to matc
and sort two colums. Let's say the first column is a list compiled b
person A and the second is a list compiled by person B. So what I nee
done is to match the ones they have in common and filter out the one
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 th
dissimilar rows. Is there an easy way of doing this
and sort two colums. Let's say the first column is a list compiled b
person A and the second is a list compiled by person B. So what I nee
done is to match the ones they have in common and filter out the one
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 th
dissimilar rows. Is there an easy way of doing this