and it's so obvious<vbg.

One to add to the UDF collection I think.

Bob

"eggsell" wrote in message
...
Jon

Thank you so much, it worked great.

Take Care



On Mon, 04 Aug 2003 14:58:43 -0400, Jon Peltier
wrote:

MIN returns 0 because the minimum occurs when (F10:F33=G5) is false
(i.e., zero). Try this one:


{=OFFSET(E1,MIN(IF(ROW(F10:F33)*(F10:F33=G5)0,RO W(F10:F33)*(F10:F33=G5)))-
1,0)}

- Jon
-------