Pugsly,

If your data is not always going to be integers then try:

=MIN(IF(A1:A99B1,A1:A99))

This is an array formula so enter ir with Control + Shift + Enter instead of
just Enter

HTH

Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"pugsly8422" wrote in message
...
I have a list of 99 different numbers. In one cell a person can type in a
number, and after they do that I want it to pick the smallest number that
is
larger than the one they listed. For example:

The list is 1,2,3,4,5

They enter 3

I want it to pick 4 since that is the smallest number that is larger than
the one they entered.

Thanks for any assistance.