View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Krill
 
Posts: n/a
Default Find first threshold violation

How can I find the location of the first incidence of a threshold amount
being exceeded in a row of unsorted data:

threshold: 45.52

44.63, 45.27, 44.98, 45.61, 45.25, 44.87, 45.63, 45.45

the answer would be 4 (45.61)