I wrote the formula assuming that there was only one * per cell.

After I had posted I thought that this:

4. To search for criterion "~**" (Tilde ** in quotation marks)

Might mean there may be multiple *'s per cell. If that was indeed the case a
simple tweak could fix things and I see Domenic has taken care of that.

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:633b2f48f3329@uwe...
Hi Biff,

Thank you for reply. I'm not sure why I do not get the Expected Results
from
your Formulae.
I copied it direct from your post and entered with Ctrl+Shift+Enter . Did
you
get the Expected Results from the Sample Data.

Expected Results:
Numeric Label has criterion asterisk on its row. Return Numeric Labels
across
a row :
4 6 7 9 10 11 12 14

Further assistance much appreciated.

Cheers,
Sam

Biff wrote:
Hi!

Try this: (based on your sample size and data)

Array entered:

=INDEX($T$2:$T$16,SMALL(IF(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0,ROW(T$2:T$16)-ROW(T$2)+1),COLUMNS($A:A)))

If you want an error trap:

=IF(COLUMNS($A:A)<=SUM(--(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0)),INDEX($T$2:$T$16,SMALL(IF(MMULT(--($U$2:$Y$16=$A$2),TRANSPOSE(COLUMN($U$2:$Y$16)^0)) 0,ROW(T$2:T$16)-ROW(T$2)+1),COLUMNS($A:A))),"")

Since it may be possible for every row in the range to contain the * you
have to copy across the equivalent number of cells.

Biff

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1