greater then...

refaeldakar · Feb 20, 2006

hello,
i want to find the minimal number that's greater then a curtain number
i provide. all in a curtain array of numbers.

thanks
refael

Bob Phillips · Feb 20, 2006

As an example

=MIN(IF(A1:A10>5,A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"refaeldakar" <[email protected]>
wrote in message
news:[email protected]...

Tom Ogilvy · Feb 20, 2006

Are the Numbers order ascending. When you say an array, are the listed in a
single column or row of cells(which) or in a VBA array?

--
Regards,
Tom Ogilvy

"refaeldakar" <[email protected]>
wrote in message
news:[email protected]...

refaeldakar · Feb 21, 2006

no the numbers aren't ascending.
the array of numbers are numbers in a curtain range in the worksheet.