greater then...

[refaeldakar]

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]

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]

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]

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