Put in A2:
=INDEX(Sheet1!A:A,MATCH(SMALL(Sheet1!$E:$E,ROWS($A $1:A1)),Sheet1!$E:$E,0))
Copy across to D1, fill down to D11
Typo correction: Last line above should be
Copy across to D2, fill down to D11
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
|