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!!
Bookmarks