Hi!

If you want the results going down the column: A4, A5, A6 etc:

Enter this formula in BestBall!A4 as an array using the key combo of
CTRL,SHIFT,ENTER:

=IF(ROWS($1:1)<=COUNTIF(Entry!F$4:F$154,"bb1"),IND EX(Entry!A$4:A$154,SMALL(IF(Entry!F$4:F$154="bb1", ROW(Entry!A$4:A$154)-ROW(Entry!A$4)+1),ROWS($1:1))),"")

Copy down until you get blanks.

If you want the results going across the row: A4, B4, C4 etc:

Enter this formula in BestBall!A4 as an array using the key combo of
CTRL,SHIFT,ENTER:

=IF(COLUMNS($A:A)<=COUNTIF(Entry!$F4:$F154,"bb1"), INDEX(Entry!$A4:$A154,SMALL(IF(Entry!$F4:$F154="bb 1",ROW(Entry!$A$4:$A$154)-ROW(Entry!$A$4)+1),COLUMNS($A:A))),"")

Copy across until you get blanks.

Biff

"rc" wrote in message
...
Single cell is preferable, but I can make do with separate cells. I know
it
is probably very easy to do, but did you forget to divulge the formula
here?

Thanks for your response.

rc


"Biff" wrote:

Hi!

So, let's say we find "bb1" at Entry!F30 and F59. The values contained
in
Entry!A30 and A59 need to display in BestBallA4.

Easily done if you put the results in separate cells. If you want all of
the
results to appear in a single cell, good luck!

Biff

"rc" wrote in message
...
I'm trying to populate a new worksheet by flagging cells in a previous
worksheet. Specifically, populate the first column of worksheet named
BestBall using this logic:

If Entry!F4:F154 = "bb1", then grab value of column A and display in
first
column of BestBall.

So, let's say we find "bb1" at Entry!F30 and F59. The values contained
in
Entry!A30 and A59 need to display in BestBallA4.


Thank you,

rc