That formula looks familiar.

Later on tonight if I'm not too busy I'll write up an explanation.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Hi Everyone

I've been reading these post for just over a year and I'm not bad with
simple formulas.
but when I see something like
this,=IF(ROWS(C$2:C2)<=COUNTIF(A$2:A$6,"*xyz*"),IN DEX(A$2:A$6,SMALL(IF(ISNUMBER(SEARCH("xyz",A$2:A$6 )),ROW(A$2:A$6)),ROWS(C$2:C2))-MIN(ROW(A$2:A$6))+1),"")
my head start spinning.
Is there a book that specialize in that type of formulas.My problem is to
follow the logic and proper syntax.
Thank you for any suggestion and Happy New Year to all.
Regards
John