Consolodating Data

[Rino468]

Hello all -- if anyone can help that would be great!!!

I have a spreadsheet about 66mb big file that has approx 400,000 lines. It is basically a list of purchases made by our company.

I am trying to look for a list of oracle products, but unfortunately Oracle has bought out many companies so doing a search for "Oracle" just does not cut it.

What ive been doing is just doing a conditional formatting to have the cell highlighted if one of the company names come up (ie: Primavera)

Is there a faster way to do this ?

Oracle owns a subset of at least 70 companies and id hate to go line by line...

Any ideas?

[ChemistB]

Make a list of all the companies and define that list as List1 (you can select that range i.e G1:G70 and type List1 into the name box and hit enter)

If your companies are in Column A starting in A2, in empty column (lets say H2)

=SUMPRODUCT(--(A2=List1))
If it's on your list, you'll get a 1, if not a 0. Filter by 1 and those are your oracle companies. Does that work for you?

[Rino468]

that works much better! thank you

[Rino468]

sorry -- where do type "List 1?" ihighlighted the appropriate cells -- but where do type LIST 1 ? or would that be the header?

[Rino468]

NM got it. thanks again