This is the formula I need to correct
=IF(NOT(A37=A38),MAX(F36:F(36-I37)),0)
I need it to find the maximum between the cell F36 and the cell FX above it, where X is defined by (36-I37).
It's probably simple I can't find correct formula to use.
This is the formula I need to correct
=IF(NOT(A37=A38),MAX(F36:F(36-I37)),0)
I need it to find the maximum between the cell F36 and the cell FX above it, where X is defined by (36-I37).
It's probably simple I can't find correct formula to use.
Is that the number 36 minus the value that is in I37?
If so, try:
=IF(A37<>A38,MAX(F36:INDEX(F:F,36-I37)),0)
If not, please explain.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks