View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill
 
Posts: n/a
Default Locate first number that exceeds reference value

How can I find the first entry in a row of unsorted data that exceeds a
reference value, eg:

Reference Value: 45.57
Data: 45.54 45.56 45.32 45.5 45.42 45.35 45.61 45.4 44.97 45 45.65 44.55

The answer should be 7 (45.61)