Excel:Need to compare serial numbers in different columns

[StarPhoenix]

Hi

I have two spreadsheets. One has a master list of asset numbers while the other has hardware audit information that includes asset numbers.

What would be the clever way of comparing the asset numbers in the first spreadsheet to those in the second
and inserting rows in the second spreadsheet for those that appear in the first but not the second.

I could probably do this all manually, and it would give me something to do today [and probably Monday as well],
but I would like to know how to get Excel to do it automagically in case I am in a hurry one day.

I am at a loss as to how to do something this complicated.

How would you do it?

Thank you

Maybe I should print out the lists and try to match these things on paper using highlighters.


Edit: Problem solved by one of my colleagues, who had it all sorted out in a matter of minutes.

I should outsource my work more regularly. :-p

[Anakha56]

Well dont leave us hanging how did your colleague do it? Someone else might find this interesting...

[StarPhoenix]

She copied and pasted the relevant columns into a new worksheet and used "Ctrl+F" repeatedly
while attempting to explain to me what she was doing. It took some time to sink in...
Then she tidied it up and emailed it to me.

I see myself being nominated for....

[Anakha56]

[Bladerunner]

Some knowledge of SAS would also have made this very easy. Just my 2c to add on to this post.

EDIT: I could actually double check your results if you send me the excel files.

[StarPhoenix]

What is SAS?

[KatrynKat]

Statistical Analysis System

something that we use to analyse our data....

[doo_much]

You could've used the 'MATCH' formula.
Remember it is an array formula and must be entered by pressing CTRL-SHIFT-ENTER.

[Bladerunner]

Statistical Analysis System

something that we use to analyse our data....

On campus you use some enterprise version which is basically point and click, according to the math stats students.

Where I work we code SAS by hand.

[Tribble]

Vloopup would have been the easiest to get the two sets of data together - an then you use the Exact() function to compare the two sets of vaules. Where you get a false you know they are different.

[KatrynKat]

@Blade: i never learnt how to use the SAS Enterprise, i learnt by typing out the codes and programs...

[Bladerunner]

@Blade: i never learnt how to use the SAS Enterprise, i learnt by typing out the codes and programs...

Well that's good; SAS programmers are few and far between.

Just out of interest, can you give me a scenario where you had to use SAS?