Hi, Appreciate your help and THANK YOU in advance
I can write this one and specify static range:
=MAX(J36:J38)
What if i need pass the cell range as numbers from other two cells , where the range is variable in my case.
for example
A2=220
B2= 670
I want to write the formula where it shows:
=max(J220:j670)
A2 & B2 are calculated automatically form other formulas
Any idea ?
Bookmarks