Jul 16 2018 07:04 AM
Jul 16 2018 07:42 AM
Jul 16 2018 07:49 AM - edited Jul 16 2018 07:50 AM
SolutionHi Randy,
Please try this formula in cell B5:
=OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)
Regards
Jul 16 2018 07:53 AM
I need to automatically calculate a value in one cell (i.e B5) when the value of other cells are updated
the formula I am currently using is SPI(B5)=f2/MAX(b3:m3)
F2 is the month of May, so when I receive the info for the month of June which will be G2, I would like the SPI value to auto calculate with out having to update the formula.
Hope this makes sense.
Jul 16 2018 07:57 AM
That worked perfectly. Thank you so much for your help!
Jul 16 2018 08:07 AM
Jul 16 2018 07:49 AM - edited Jul 16 2018 07:50 AM
SolutionHi Randy,
Please try this formula in cell B5:
=OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)
Regards