Thank you All for your comments.
It's appreciated, I will keep reading these post and practice.
All the best for the NewYear to you All
Regards
John
"T. Valko" wrote in message
...
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