Hi,
Let's say these cells contain these values:
cell a1=212
cell a2=324
cell a3=488
cell a4=538
cell a5=498
cell a6=444
I have a "threshold" value of 500.
I would like Excel to return the highest value that occurs before (in the array order) the threshold. (In this case the value would be 488). I need to keep the list unsorted. It would be best if I could find a formula (rather than VBA solution) for the sheet that I am using.
Any ideas? Thank you!
Let's say these cells contain these values:
cell a1=212
cell a2=324
cell a3=488
cell a4=538
cell a5=498
cell a6=444
I have a "threshold" value of 500.
I would like Excel to return the highest value that occurs before (in the array order) the threshold. (In this case the value would be 488). I need to keep the list unsorted. It would be best if I could find a formula (rather than VBA solution) for the sheet that I am using.
Any ideas? Thank you!