I'm not sure how to do this but this is what I want to do.
A B
6/27/05 262A029
6/23/05 267A042
6/24/05 267A043
6/24/05 271A001
I want to search column A for a certain date and pull out the data on
column B but some dates have multiple matches on column B. I need all
the column B data that matches the date. So in the example I
have...When I search for 6/24/05 in column A I get "267A043" and
"271A001" from column B. Can someone please help me!!!

Thanks


--
cutsygurl
------------------------------------------------------------------------
cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041
View this thread: http://www.excelforum.com/showthread...hreadid=382792

cutsygurl Wrote:
I'm not sure how to do this but this is what I want to do.
A B
6/27/05 262A029
6/23/05 267A042
6/24/05 267A043
6/24/05 271A001
I want to search column A for a certain date and pull out the data on
column B but some dates have multiple matches on column B. I need all
the column B data that matches the date. So in the example I
have...When I search for 6/24/05 in column A I get "267A043" and
"271A001" from column B. Can someone please help me!!!

Thanks

Assuming your data range is A1:B50, try this ...

1. Enter the date in, for example, Cell C1
2. In Cell C2, enter this formula

=INDEX($B$1:$B$50,SMALL(IF($A$1:$A$50=C$1,ROW($B$1 :$B$50)),ROW(1:1)))

NOTE: This is an array formula so commit with Ctrl-Shift-Enter keys.

3. Copy down this formula up to any cell where you want to stop (from
C3 to anywhere you'd like to stop on Column C).

... hope this is the formula you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=382792

That is exactly what I needed. Thank you sooo much


--
cutsygurl
------------------------------------------------------------------------
cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041
View this thread: http://www.excelforum.com/showthread...hreadid=382792

You are welcome ... glad that I can be of help.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=382792