Re: need help ASAP


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, simply turn on autofilter and filter out all the "No Match".


Hope this helps.




pike188 Wrote:
> 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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094
View this thread: http://www.excelforum.com/showthread.php?threadid=377067

.

Relevant Pages

  • Re: can LOOKUP function compare text instead of numerical data?
    ... Can LOOKUP function compare text in cells instead of numerical data? ... cheerboy555's Profile: ...
    (microsoft.public.excel)
  • can LOOKUP function compare text instead of numerical data?
    ... Can LOOKUP function compare text in cells instead of numerical data? ... cheerboy555's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33989 ...
    (microsoft.public.excel)
  • Re: math problem
    ... > TIA ... Morrigan ... Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need similar formulas to do the job
    ... Hi Morrigan ... I tried the Text to Column story, It worked, ... sonar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8424 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Count # of cells b/w cells ...
    ... Now make a table of the side again with 4 Columns, headers will be: ... > Thanks, Morrigan - it worked. ... Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094 ... Prev by Date: ...
    (microsoft.public.excel.misc)