pass range number to formula from different cells

[ElGendi]

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 ?

 

[alansidman]

crossposted: pass the range number in formula

 

[mole999]

@ElGendi
Cross Posted

Your post has been reported as being cross posted with another site.

Whilst we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: > (Message Board Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please provide the link(s) ASAP.

 

[ElGendi]

Pardon , didnt mean that , I was trying to get help anyhow / anywhere
thanks for the advice

pass the range number in formula [SOLVED]

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

www.excelforum.com