1

Topic: The maximum value on a condition

Hello!
Microsoft Excel 2013 is used.
There is a table on +SKU+.
[spoiler the Table] a TT, SKU, Date, The Price, The Ceiling price for current and last month, The Ceiling price for current and 2 last months
1, SKU1, 01.02.2018, 150, 150, 150
1, SKU1, 09.02.2018, 140, 150, 150
1, SKU1, 19.02.2018, 120, 150, 150
1, SKU1, 06.03.2018, 130, 150, 150
1, SKU1, 26.03.2018, 120, 150, 150
1, SKU1, 02.04.2018, 110, 130, 150
1, SKU1, 08.04.2018, 105, 130, 150
1, SKU1, 17.04.2018, 90,130, 150
1, SKU1, 01.05.2018, 85, 110, 130
1, SKU2, 01.02.2018, 150, 150, 150
1, SKU2, 09.02.2018, 140, 150, 150
1, SKU2, 19.02.2018, 120, 150, 150
1, SKU2, 06.03.2018, 130, 150, 150
1, SKU2, 26.03.2018, 120, 150, 150
1, SKU2, 02.04.2018, 110, 130, 150
1, SKU2, 08.04.2018, 105, 130, 150
1, SKU2, 17.04.2018, 90, 130, 150
1, SKU2, 01.05.2018, 115, 115, 130
[/spoiler] I Try to write function in excel for fields the Ceiling price for current and last month and the Ceiling price for current and 2 last months . For the total it turns out, and for  - is not present.
Tell, how in excel to register the formula for this field?

2

Re: The maximum value on a condition

Question - "as in excel to register the formula".
Something is conceived foggy or so vaguely it is stated.
Variant - summary with grouping of dates on months and quarters.  - on the taste... wink

3

Re: The maximum value on a condition

Volodshan wrote:

vaguely it is stated

The formula should be registered in this clever table.

4

Re: The maximum value on a condition

Wrote so - also does not work

5

Re: The maximum value on a condition

6

Re: The maximum value on a condition

And so does not work here.

7

Re: The maximum value on a condition

8

Re: The maximum value on a condition

More truly considers not how it is necessary

9

Re: The maximum value on a condition

It's a go. It appears it was necessary to make through the formula of an array and to specify an initial and last line, instead of so A:A.

10

Re: The maximum value on a condition

1. Whether probably in the formula to use record of type A:A, instead of A$2:A$19? Record of type A$2:A$19 becomes that titles did not get, differently the formula does not work.
2. The first variant does not work. Why?

11

Re: The maximum value on a condition

ferzmikk wrote:

1. Whether probably in the formula to use record of type A:A, instead of A$2:A$19?

Probably, you simply did not learn to work yet with "clever" tables. In nesting an example of your formula for the clever table. At adding of the new data all will be APPRX.

12

Re: The maximum value on a condition

Still passed by;
Thanks