need help with simple excel workings.
#1
Registered User
Thread Starter
Join Date: Feb 2005
Location: boston, ma
Posts: 607
Likes: 0
Received 0 Likes
on
0 Posts
need help with simple excel workings.
hey guys. just started a new job today on the other side of production. rather than building unix servers, i am not on the sales support side. i was given a task to compare 2 excel spreadsheets, both having a column with serial numbers, among other columns with misc. info. i need to compare the 2 lists of serial numbers and come up with a list of serial numbers that are NOT on both.
how do i go about doing this? i know it can be done, but i am not that good with excel...yet. thanks.
how do i go about doing this? i know it can be done, but i am not that good with excel...yet. thanks.
#2
Contributing Member
Join Date: Feb 2004
Location: tulsa, OK
Posts: 1,318
Likes: 0
Received 0 Likes
on
0 Posts
the vlookup function will work really well, let me dig up a quick explanation from an old post.
edit: here it is
highlight the second set of data & name that range something, like 'data'.
in the first empty column on the first sheet use vlookup, formula should be something like
=vlookup(a2, data, 2, false)
where a2 is the cell with the ssn you want to find a match for, data is the name of the second block of data, 2 is the column in data that has email addresses, and false tells it to only return exact matches.
The named range needs to have the ssn in the leftmost column of the named range.
let me know if this doesn't make sense, i know the feild names probably don't apply for your scenario.
edit: here it is
highlight the second set of data & name that range something, like 'data'.
in the first empty column on the first sheet use vlookup, formula should be something like
=vlookup(a2, data, 2, false)
where a2 is the cell with the ssn you want to find a match for, data is the name of the second block of data, 2 is the column in data that has email addresses, and false tells it to only return exact matches.
The named range needs to have the ssn in the leftmost column of the named range.
let me know if this doesn't make sense, i know the feild names probably don't apply for your scenario.
Last edited by tulsa_97SR5; 11-14-2005 at 04:45 PM.
#3
Registered User
Thread Starter
Join Date: Feb 2005
Location: boston, ma
Posts: 607
Likes: 0
Received 0 Likes
on
0 Posts
blocks mean seperate files, correct?
should i just make a new sheet, using column a and b with just the serial numbers, and try to run this? and if i want just the ones that don't match...instead of using false, should i use true?
should i just make a new sheet, using column a and b with just the serial numbers, and try to run this? and if i want just the ones that don't match...instead of using false, should i use true?
#4
Contributing Member
Join Date: Feb 2004
Location: tulsa, OK
Posts: 1,318
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by bflooks
blocks mean seperate files, correct?
should i just make a new sheet, using column a and b with just the serial numbers, and try to run this? and if i want just the ones that don't match...instead of using false, should i use true?
should i just make a new sheet, using column a and b with just the serial numbers, and try to run this? and if i want just the ones that don't match...instead of using false, should i use true?
It's like a SELECT statement if you've worked with SQL much, with the named ranges acting like tables.
Thread
Thread Starter
Forum
Replies
Last Post
kawazx636
The Classifieds GraveYard
34
10-06-2021 03:03 PM
live4soccer7
84-85 Trucks & 4Runners
3
05-11-2016 06:52 PM