Hi!

Entered as an array with the key combo of CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)<=COUNTIF(Sheet1!B$2:B$8,"vac"),INDE X(Sheet1!A$2:A$8,SMALL(IF(Sheet1!B$2:B$8="vac",ROW (Sheet1!A$2:A$8)-ROW(Sheet1!A$2)+1),ROWS($1:1))),"")

Copy down until you get blanks.

Biff

"smoore" wrote in message
oups.com...
I have a list of Dates in Col. A
Column B contains both numerical and text values.
I need to define a value in column B, and create a list of the dates
that these occured on, on another sheet. Auto filter doesn't work
because there are several different columns. If I try to use it I also
get the values in the other columns.


A B
1/2 8
1/3 4
1/4 Vac
1/5 8
1/6 7
1/7 Vac
1/8 8



Value needed = Vac

Solution 1/4
1/7

Thanks for any and all help.