I am sure there is a better way than this, but you could
write a self defined function to do this then use it in
your sheet to give you the answer (remember to use the
whole list area as a call function or the macro won't
always update)

Just as a afterthought carn't you just order the list?
-----Original Message-----
i am trying to find a way to combine formulas to look up
the second
largest entry in a list.

any ideas?


---
Message posted from http://www.ExcelForum.com/

.