SOLVED

how to make cell ranges static

New Contributor

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.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @abdulrazzaq1968 

 

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.