You're welcome!

--
Biff
Microsoft Excel MVP


"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:84ce899a10002@uwe...
Dear T.Valko,
Many thanks for your advice!

Wilchong



T. Valko wrote:
Try this array formula** :

=INDEX(A$3:A$7,MATCH(SMALL(B$3:B$7+ROW(B$3:B$7 )/10^10,ROWS(C$3:C3)),B$3:B$7+ROW(B$3:B$7)/10^10,0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Dear T. Valko
I have use your suggested formula and it has proven very efficient if
[quoted text clipped - 17 lines]

Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200805/1