Hi all,
I am in need of making an excel sheet from 3 other separate worksheets into 1, merging in a way.
I have 3 separate worksheets that list account numbers in them, no duplicates in these separate sheets. I am trying to take these 3 separate sheets and only keep the account numbers that have appeared in all 3 sheets and make a new sheet displaying just the one account number. Is there a way to do this in excel? My account numbers are in the A column for all sheets.
Thanks.
Bookmarks