Previous Topic Next Topic

Combination from .xls using unique identifier

Closed
santanto - Apr 19, 2011 at 12:12 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 20, 2011 at 02:20 AM
Hello,

I have 2 worksheets each with employee information. 1 has all new employees in a time period, and the other contains their personal details (master). The common identifier for these employees is their SSN (in both worksheets).

I want to extract a list from the master worksheet (with all related data) of all those new employees and write them to another sheet.

I'm using excel 2007, but also need the process for a colleague on 2003.

Thank you in advance

1 response

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 20, 2011 at 02:20 AM
You "VLOOKUP" to get the required result.

make a temporary column next to SSN in Master Data, use VLOOKUP:

now filter for values not equal to #N/A.

Now copy the data and paster to new sheet.

then delete temp. column.

Hope this will clear to you.

Thanks,
0

Similar discussions

Find my Gmail account
Dabang -
HelpiOS -

1 response
Facebook message show confirm your identity
Shehryar01 -
Ambucias -

7 responses
Why can't I create account
Ol -
HelpiOS -

1 response
Confirm your identity with phone or computer
Sajibdas217@gmail.com -
ElenaKM -

1 response
karbonn k10 password
raj -
jack4rall -

1 response