Alternatively, select F16:F17, put in the formula bar:
=IF(ISERROR(SMALL(IF(E16:E20<"",ROW(A1:A5)),ROW(A 1:A5))),"",
INDEX(E16:E20,MATCH(SMALL(IF(E16:E20<"",ROW(A1:A5 )),ROW(A1:A5)),ROW(A1:A5),
0)))
Then array-enter the formula (i.e. press CTRL+SHIFT+ENTER)
instead of just pressing ENTER
F16:F17 would also return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---