Hello,
I have attached a sample spreadsheet of the problem.
The end goal I am trying to achieve is to get the absolute min next value to d21 that does not include e21 as an answer. However e21 still must remain in the index. Formula that is used works, but in certain circumstances e21 will populate as the answer. Formula is in I21.
Correct answer that I am looking for is e57. Sheet formatting must remain the same. Must be ABS as as some correct answers will read negative due to date change.
Thanks for the help!
Bookmarks