View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default First occurance greater than or equal to a specified value

Assuming that A1:A10 contains your data, and B1 contains the 'specified
value', try...

=INDEX(A1:A10,MATCH(TRUE,A1:A10=B1,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article .com,
wrote:

Hey-

I have a list of unsorted data and I want to proceed from the top of a
known column to the bottom and return the first number that is greater
than equal to a specified value.

DMIN doesn't work because I want the first occurance that is greater
than the specified value, not necessarily the smallest number.

Thanks.
-Rob