How to compare columns of 2 different Excel
Solved/Closed
prathibha
-
Apr 14, 2011 at 11:50 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 15, 2011 at 01:16 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 15, 2011 at 01:16 AM
Related:
- How to compare columns of 2 different Excel
- Tentacle locker 2 - Download - Adult games
- Call of duty modern warfare 2 2022 free download - Download - Shooters
- Fnia 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Euro truck simulator 2 download free full version pc - Download - Simulation
3 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 15, 2011 at 12:31 AM
Apr 15, 2011 at 12:31 AM
This example look like that you want employee ids in sheet 2 which are not in sheet 1.
Supose your employee id is in Column B of both sheet.
now in sheet 2
insert a column next to B,
put formula in C2 as
=VLOOKUP(B2,Sheet1!B:B,1,FALSE)
drag it to last row.
now filter the value #N/A is the employee who are not in sheet 1.
Hope this will helps you.
Supose your employee id is in Column B of both sheet.
now in sheet 2
insert a column next to B,
put formula in C2 as
=VLOOKUP(B2,Sheet1!B:B,1,FALSE)
drag it to last row.
now filter the value #N/A is the employee who are not in sheet 1.
Hope this will helps you.
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 15, 2011 at 01:16 AM
Apr 15, 2011 at 01:16 AM
You are most welcome,
We (Members of the form) enjoy to help you.
We (Members of the form) enjoy to help you.