Increment cells in a specific way

[Nathaaan30]

Hello, I have a fairly specific question and not knowing how to formulate it, I did not find an answer on the internet.

Let's take a B1 cell, I want in this box B1 to have the maximum value among the values of A1:A50, so I write =MAX(A1:A50).

Now in my next box (B2), this time I want to have the maximum value of boxes A100:A150.

The problem is that by using autofill, the software writes =MAX(A2:A51) and not =MAX(A100:A150).

I tried to "fix" the dozens and units of my colones with a $ (with =MAX(A0$1:A0$50) but it doesn't work, so I rely on you.

Thank you in advance.

 

[etaf]

will this continue to be copied down
so
in b3
what ????

etc

maybe be possible with row() and some multiple

 

[James006]

Hi,
After cell B1 and cell B2 ... is there a cell B3 ?

 

[Nathaaan30]

will this continue to be copied down
so
in b3
what ????

etc

maybe be possible with row() and some multiple

Hello,

Yes, after the B2 cell there must be a B3 cell that will have to return the maximum of A200:A250, then a B4 that will give the maximum for A300:A350, and so on...

 

[Nathaaan30]

Hi,
After cell B1 and cell B2 ... is there a cell B3 ?

Hello,

Yes, after the B2 cell there must be a B3 cell that will have to return the maximum of A200:A250, then a B4 that will give the maximum for A300:A350, and so on...

 

[Nathaaan30]

Hello, I have a fairly specific question and not knowing how to formulate it, I did not find an answer on the internet.

Let's take a B1 cell, I want in this box B1 to have the maximum value among the values of A1:A50, so I write =MAX(A1:A50).

Now in my next box (B2), this time I want to have the maximum value of boxes A100:A150.

The problem is that by using autofill, the software writes =MAX(A2:A51) and not =MAX(A100:A150).

I tried to "fix" the dozens and units of my colones with a $ (with =MAX(A0$1:A0$50) but it doesn't work, so I rely on you.

Thank you in advance.

J’ajoute une précision car la question m’a était posé :

Les cellules en B continue après B2 de la même manière, de sorte que B3 doit renvoyer le maximum pour A200:A250,
B4 => MAX(A300:350)
B5 => MAX(A400:450)
…
En formule « général » on pourrait écrire :

Bn=> MAX(A(n-1)*100):A(n-1)*100+50)

Mais je n’ai pas la bonne formulation pour le logiciel

 

[Fluff]

Please post to this board in English only.
If you wish to post in your native language then you should post in the Questions in Other Languages section
Thanks

 

[Nathaaan30]

Forgot to translate, sorry

I add a clarification because the question was asked to me:

The B cells continue after B2 in the same way, so that B3 must return the maximum for A200:A250,

B4 => MAX(A300:350)

B5 => MAX(A400:450)

...

In the "general" formula we could write:

Bn=> MAX(A(n-1)*100):A(n-1)*100+50)

But I don't have the right wording for the software

I forgot to translate the message, sorry

I add a clarification because the question was asked to me:

The B cells continue after B2 in the same way, so that B3 must return the maximum for A200:A250,

B4 => MAX(A300:350)

B5 => MAX(A400:450)

...

In the "general" formula we could write:

Bn=> MAX(A(n-1)*100):A(n-1)*100+50)

But I don't have the right wording for the software

 

[James006]

Merci beaucoup pour les précisions !!!

Thanks a lot for the added détails !!!

 

[Nathaaan30]

Please post to this board in English only.
If you wish to post in your native language then you should post in the Questions in Other Languages section
Thanks

No problem, I just forgot to translate but communicating in English does not cause me any problems, a simple mistake on my part, sorry...