Forum Discussion
Randy Tibbits
Jul 16, 2018Copper Contributor
Help trying to auto calculate one cell when other cells are populated.
- Jul 16, 2018
Hi Randy,
Please try this formula in cell B5:
=OFFSET(A3,-1,COUNTA(B3:M3))/MAX(B3:M3)
Regards
Randy Tibbits
Jul 16, 2018Copper Contributor
That worked perfectly. Thank you so much for your help!
JKPieterse
Jul 16, 2018Silver Contributor
Thank you for adding your question!