Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate first number that exceeds reference value
Try...
=MATCH(TRUE,A1:L145.57,0) and =INDEX(A1:L1,MATCH(TRUE,A1:L145.57,0)) Both formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the range accordingly. Hope this helps! In article , "Nick Krill" wrote: 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate first number that exceeds reference value
On Thu, 5 Jan 2006 12:51:04 -0800, "Nick Krill"
wrote: 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) You really should try to keep your threads together. What was the matter with the response I posted last night? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
number of fields exceeds 256 when importing from a dbf file | Excel Discussion (Misc queries) | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
return the column reference number of a function result | Excel Discussion (Misc queries) |