Probably just need to make an arithmetic adjustment to the 2nd formula
Eg if your source data starts in row 4 down in Sheet1
In another sheet,
In A2: =IF(Sheet1!B4="y",ROW(),"")
In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(Sheet1!A:A,SMAL L(A:A,ROWS($1:1))+2))
The "+2" is the required adjustment

And if you have more than 1 source col to return from Sheet1,
just fix the point to col A: $A:$A in the 2nd formula
ie use in B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Sheet1!A:A,SM ALL($A:$A,ROWS($1:1))+2))
Copy B2 across by as many cols as required. Then select n copy A2:Z2 (say)
down to cover the max expected extent of source data, eg down to Z200?
Hide/minimize col A. Cols B to Z will auto-return the required list of
source lines satisfying the criteria as the source data changes, with all
results neatly packed at the top

Try the above first. It should clear it up and get it going sweetly for you
You can use this link to upload a sample
http://cjoint.com/

--
Max
Singapore
------
"Madeline Koch" wrote in message
...
Thanks, Max. I wanted it to be a dynamic list so Stefi's suggestion was
not
quite right for my purposes.

I kind of got this to work, but I don't know how to get the list of the Ys
all at the top.

If I sent you a dummy file you could see what I've done (it's very
difficult
to explain here, but I could try...!)

Cheers,
Madeline