Necessary to Name & Division to tighten the value of the norm with the last date of change
- And then css? - ishidex2
- @ Engineer, are the values in the worksheet in column A sorted? Result pull where? In all rows of a column or in a cell when specifying Names and Divisions - vikttur
|
1 answer
The date in Excel is a number: the number of days from 01/01/1900 (for demonstration in the figure, dates are shown in a numeric format). For example:
10.05.2000=36656 20.10.2017=43028 This can be used to simplify calculations.
=ОКРУГЛ(--ПСТР(МАКС(ЕСЛИ($A$2:$A$13=A2;ЕСЛИ($B$2:$B$13=B2;$C$2:$C$13+$D$2:$D$13/1000)));6;9)*1000;2) The array formula is entered by simultaneously pressing the Ctrl + Shift + Enter buttons, and the formula must be framed with curly braces.
vikttur vikttur
5.440 3 eleven 22
|