Thread
:
Find first threshold violation
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Nick Krill
Posts: n/a
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)
Reply With Quote