How to select certain cells in a column ?

[Mark246]

Excel 2007...

In Column A are the 1,200 ID numbers that I want, in sequence.
They're not all consecutive numbers.
No numbers are repeated.
They range from 11 to 4,300.

In Column B are all 140,000 ID numbers, also in sequence.
Some numbers are repeated. They range from 5 thru 6,000.

Is there a way to select only the cells / rows in Column B that match
the ID numbers in Column A?

Thanks, in advance.

Mark246

 

[Max]

Is there a way to select only the cells / rows in Column B that match

the ID numbers in Column A?

One quick & easy way is to use autofilter on a helper col
Assuming source data in cols A & B, data from row2 down
Put in C2:
=IF(B2="","",--ISNUMBER(MATCH(B2,A:A,0)))
Copy C2 down to the last row of data in col B
Select col C, apply autofilter, choose: 1 from the droplist
The resulting filtered rows in col B will be what you're after

---

 

[Mark246]

That sorta' works, Max. Almost. Thanks, but...

About 80% of the 140,000 records have the ID of 1557.
Starting at #24,643, ALL of the records after that have that ID #1557.
Records from #24,643 to 91,884 all indicate "0" in Column C, as they
should.

For some reason,... starting at record # 91,885,
some of the records show "0" and some show "1".

I can see no pattern as to why this happened.

Have ya' got an explanation?

Thanks.

Mark246

 

[Max]

For some reason,... starting at record # 91,885,

some of the records show "0" and some show "1".

I can see no pattern as to why this happened.

Think you've got a data consistency issue. Some numbers are text numbers,
some are real numbers. Try this to convert all data to real numbers. Copy a
blank cell, then select entire cols A and B, right-click > paste special >
Check "Add" > OK.

---