Thanks for letting me know that worked for you.....I'm glad I could help.


***********
Regards,
Ron

XL2002, WinXP


"inta251 via OfficeKB.com" wrote:

This is just perfectoooooo!!!!!
I did just as you posted. Working 100%+.
To make nice view, i just hide column A.
Sometime i am wondering, how you guys can keep in the head all this formulas.
Anyway, THANKS for your help.
Sincerely, Igor. (inta251)
Put this formula in B2 and copy down
=T(LOOKUP(MATCH(SMALL(INDEX(COUNTIF($A$1:$A$10,"< "&$A$1:$A$10)+($A$1:$A$10="")*10^10,0),ROWS($A$2:A 2)),INDEX(COUNTIF($A$1:$A$10,"<"&$A$1:$A$10)+($A$1 :$A$10="")*10^10,0),0),ROW($A$1:$A$10),$A$1:$A$10) )


--
Message posted via http://www.officekb.com