Not sure what I need

edsjr · Mar 28th, 2002, 05:18 PM

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 · Mar 28th, 2002, 05:27 PM

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 · Nov 13th, 2007, 05:43 PM

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.

Nov 13th, 2007, 05:43 PM	#3
juniog95 New Member Join Date: Nov 2007 Posts: 1	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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 05:18 PM	#1
edsjr New Member Join Date: Mar 2002 Location: Illinois Posts: 19	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 ]

Mar 28th, 2002, 05:27 PM	#2
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	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