Filter Two lists (multiple columns)

I have two lists over multiple columns

List A = Columns A, B, C (Name, Age, Class)
List B = Columns F, G, H (Name, Age, Class)

and I need to filter them so I have 3 outputs

Unique to List A
Unique to List B
Match in List A and B

I have attached a workbook with a made up example. It has the original lists, and how the lists should appear once filtered. you can work with this book if its easier.

Could someone show me or explain to me how to filter these lists?

All help is appreciated and many many thanks!!

Hi,

Take a look here this might help?

http://chandoo.org/wp/2008/11/06/uni...ms-excel-help/

See attached.

Added helper columns next to the lists to determine which to include/exclude

Note: Your sample did show Brian as having same age in both lists.. I changed one to age 15 to show results you expected.

Formula in D3 (No Match):

Please Login or Register  to view this content.

Formula in E3 (Match):

Please Login or Register  to view this content.

Formula in I3 (No Match):

Please Login or Register  to view this content.

each of above copied down.

Formula in B18:

Please Login or Register  to view this content.

finds max entries

Formula in A20:

Please Login or Register  to view this content.

copied across and down the first filter....

Formula in G18:

Please Login or Register  to view this content.

Formula in F20:

Please Login or Register  to view this content.

copied across and down

Formula in K18:

Please Login or Register  to view this content.

Formula in J20:

Please Login or Register  to view this content.

copied across and down.