need help ASAP


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


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

.

Relevant Pages

  • Re: AARP Woodworkers - Home Depot Discount!
    ... Limit of $500 worth of cards per day. ... Not a whole lot, but hey, every little bit helps. ... Prev by Date: ...
    (rec.woodworking)
  • Re: Is anyone ever going to make some JD cabinet decals??
    ... Hey, I'm right with you guys, I would buy them in a second. ... JD dont get the same respect as FT and HSII unfortunately, ... Prev by Date: ...
    (rec.games.pinball)
  • Re: Las Vegas, anyone?
    ... > Hey, Neal being on a roller derby team would be worth going ANYWHERE to ... Prev by Date: ...
    (sci.med.transcription)
  • unlock nokia phone
    ... hey guys i have a nokia 3310 phone which needs to be unlocked, ... the software to generate the code but dont know the process as how to ... Prev by Date: ...
    (alt.comp.hardware.pc-homebuilt)
  • Super Contran and LED Storn JAMMA Boards?
    ... I have these two boards and dont know how much they are worth, ... anyone have an Idea..They both worked when pulled from the games, ... Prev by Date: ...
    (rec.games.video.arcade.marketplace)