Looking for an excel compare program

[markrb]

I know this is way off the A/V topic, but some of the people here are beyond genius in the programming world and might have an opinion that can help me.

I am looking for a program that I can take 2 excel, spreadsheets, compare them and then remove all the items found in file 1 from file 2.

Exactly what I am trying to do is this.
I program for both surface mount machines and thru-hole machines. Both parts come on one list of materials and it's time consuming to split them manually. I plan to create 2 spreadsheets one with all known SMT parts and one with all known thru-hole parts. Then I would like to run a compare with my part list build data against one or the other and have it remove all the known parts of the type I am not using. Removing the known parts of the other type will be safer incase a new part is listed.

I have searched and found a few out there, but I was wondering if anyone here has used anything like this and can recomend one to try. It can't be very expensive as my boss is rather cheap and if it had a free to try demo that would help to justify any cost and prove my method.

Thanks,
Mark

[bb]

To me this sounds like a (small) VBA programming job, because what you intend to do seems to be too individual for a standard solution.

bb

[setarip_old]

@markb

For the purpose of comparison, put both lists on ONE spreadsheet.

In Excel, click on help - and enter the word "compare", select "Compare cell contents" and then select "Compare one value to a list of values".

With minor modification, you should be able to compare EACH value of the second list to each value in the first list.

Let us know how it goes ;>}

[Shinigami-Sama]

if you have access to a *nix system
you can expert the files to csv and use the cmp function I beleave it is

[grannyGeek]

markrb, are you still seeking a solution?

I could write you a small VBA Excel macro routine that could do it quite handily, if all your SMT parts all have the same unique identifier in the stock number or such, that the other type of parts do not have.

PM me if you are interested.
I luv working with excel
:)


granny