I am trying to find the min price in column E, in column G there is an indicator of when the range changes, the X in column H is my manual checkmark to show the lowest price, what i would like is to have a formula to show the lowest price instead of my manual method.
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:D26 | D2 | =IF(U2="","",U2) |
E2:E26 | E2 | =IF(W2="","",W2) |
F2:F26 | F2 | =IF(Y2="","",Y2) |
G3:G26 | G3 | =IF(R3="","",IF(R2=R3,G2,G2+1)) |