9/1/14 | 25000 |
9/2/14 | 26000 |
9/3/14 | 27000 |
9/4/14 | 28000 |
9/5/14 | 29000 |
<tbody>
</tbody>
I have tried Vlookup and I have tried an array, but can't seem to get it to work.
Ideas most welcome.
9/1/14 | 25000 |
9/2/14 | 26000 |
9/3/14 | 27000 |
9/4/14 | 28000 |
9/5/14 | 29000 |
Yes, always ascending order.
For the most part, this has worked very well. I've been using it in 4 different spreadsheets. Every once in a while, it will jump to the last date. If I make the criteria 27499.9, it will usually work, but I have a new case and the "fix" will not work. I also have a new case where all the depths out of 120 are ascending, but the last 6 descend.
Advise?
Thanks in advance!
Because I enter the depths manually and I know the last 2 to 6 depths will decrease significantly