06-07-2005, 11:04 AM
|
|
Valued Forum Contributor
|
|
Join Date: 12 Mar 2004
Posts: 323
|
|
Assume A1:A2000 are numbers that you are trying to match with B1:B2000, you can try this:
C1 = IF(ISERROR(MATCH(B1,$A$1:$A$2000,0)),"No Match","Match")
C2 = IF(ISERROR(MATCH(B2,$A$1:$A$2000,0)),"No Match","Match")
etc.
Now if you want to view all the numbers in column A that also exist in column B, simply turn on autofilter and filter out all the "No Match".
Hope this helps.
Quote:
|
Originally Posted by pike188
hey all, I'm having a problem and dont know exactly how to do this...
I have one column of data (2000 lines worth) all are numerical and all are different, this is column A
in column B I have another list of numerical data, most of this data will match the data in column A, but not all.
what I'm trying to do is to pull out of column A all the numbers that have a match in column B,
How do I do this?
thanks
Ryan
|
|