Thread
:
First occurance greater than or equal to a specified value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Domenic
Posts: n/a
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
Reply With Quote