Not sure what I need

[edsjr]

Hello, I am new to this forum and hope you can help me.

I have 30,000 rows with 4 columns. I need to put a similar list next to the first column and compare them to see if any in the second column are not in the first column. They are product numbers and I need to have like ones next to each other for a cost comparison.

Thank you in advance
Ed.
This message was edited by edsjr on 2002-03-28 16:34
This message was edited by edsjr on 2002-03-28 18:28

 

[Paul-Johnson]

Try using advanced filters.

The list with four columns is your range and the single column list is your criteria.

Be sure that the column headings on the range are IDENTICAL to the criteria range

 

[juniog95]

Similar issue, but slightly different

I have two columns of data I'm comparing - column A has account numbers of a similar, but not identical format to account numbers in column B.

What function can I use to determine if the account numbers in column A exist in column B?

Data example:
Cell A1 = 670112020112
Cell B1 = 670112020

VLOOKUP with a Range_Lookup = TRUE argument doesn't work, as there's no rounding involved here.