Forum Discussion
Solved
how to make cell ranges static
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.
You can freeze cell range by wrapping them with $. Paste the below formula in C2.
C1=B1/MAX($B$1:$B$10)
Thanks
Tauqeer
2 Replies
You can freeze cell range by wrapping them with $. Paste the below formula in C2.
C1=B1/MAX($B$1:$B$10)
Thanks
Tauqeer
tauqeeracma thanks a lot. Your suggested solution solved my problem.
