MS Excel 2010
Posted on 2014-11-14
I have 2 different spread sheets with the same following headers: Username, Displayname, Email.
Is there a way for me to grab the similarities of the Username, and have all those copied to a new column, new sheet or anything? So from the 2 spread sheets I basically want to grab all the usernames that are same. example: sheet 1 has 5 usernames and sheet 2 has 20 user names. I want to compare the username value of the 2 sheets and get just user name that appears on both sheets. Hopefully this can be done without needing any add-ons.