Dec 14 2021 06:03 PM
I want to make range static for all cells in a column. For example I want to calculate c1=b1/max(b1:b10) and then c2=b2/max(b1:b10). In this I want to keep max(b1:b10) unchanged for all cells in column c.
Dec 14 2021 07:08 PM
Solution
You can freeze cell range by wrapping them with $. Paste the below formula in C2.
C1=B1/MAX($B$1:$B$10)
Thanks
Tauqeer
Dec 14 2021 09:01 PM
@tauqeeracma thanks a lot. Your suggested solution solved my problem.
Dec 14 2021 07:08 PM
Solution
You can freeze cell range by wrapping them with $. Paste the below formula in C2.
C1=B1/MAX($B$1:$B$10)
Thanks
Tauqeer