MAX function in Excel is it possible to provide the range by means of variables

0 votes

In order to calculate the MAX of a range, I'm attempting to develop an excel formula. References are recognized by the default formula as the limits of the admissible range of arguments:

=MAX(A1:A10)

By entering them in specific cells, I want to make the range's boundaries into variables, like:

=MAX(A"number of row taken from the content of cell B2":B"number of row taken from the content of cell B3)

See the attached screenshot.

Is this format supported by Excel? If yes, what's the correct syntax? Thank you!

enter image description here

Nov 15 in Others by Kithuzzz
• 20,660 points
26 views

1 answer to this question.

0 votes

Try this:

=MAX(INDEX(A:A,B2):INDEX(A:A,B3))
answered Nov 15 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Where is the documentation to refer for coinbase api integration of Etherium coin currency in php?

Hey there! Please refer to the following ...READ MORE

answered Jan 25, 2019 in Others by Omkar
• 69,210 points
319 views
0 votes
1 answer

What is a name function in JavaScript & how to define it?

A named function declares a name as ...READ MORE

answered Mar 7, 2019 in Others by Frankie
• 9,830 points
1,718 views
0 votes
0 answers
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
242 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
71 views
0 votes
1 answer

Is it possible to round to different decimal places in excel based on the range?

Where the range is multiple cells: Excel.Worksheet sheet ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
28 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP