let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    a=Table.ColumnNames(Source),
    b=List.Count(a)-1,
    c = List.PositionOf(a,"нач. остаток")+1,
    d = List.Range(a,c,b-c),
    d2 = List.Transform(d, each Date.ToText(Date.From(_), "MMM.yyyy")),
    Custom1 = Table.AddColumn(Source, "aa", each List.NonNullCount(Record.ToList(Record.SelectFields(_,d)))),
    #"Renamed Columns" = Table.RenameColumns(Custom1,List.Zip({d,d2}))
in
    #"Renamed Columns"

{1..12}

let
    a = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    b = a[#"Кол-во дней"]{0},
    c = a[сумма]{0},
    d = Number.From(Date.From(DateTime.LocalNow()))+1,
    e = {d..d+b-1},
    f = Table.FromColumns({e,{c}}),
    g = Table.FillDown(f,{"Column2"}),
    i = Table.AddIndexColumn(g, "Индекс",  1)
in
    i

=ИНДЕКС(A5:A25;ПОИСКПОЗ(МИН(1/A5:A25);1/A5:A25;))

let
    a={"БЛОК", "ЛИНИЯ", "НАИМЕНОВАНИЕ МТР", "ДУ"},
    b={"БЛОК", "ЛИНИЯ", "НАИМЕНОВАНИЕ МТР"},
    Источник = Table.NestedJoin(Таблица1,a,Таблица13,a,"a",1),
    Custom1 = Table.NestedJoin(Источник,b,Таблица13,b,"b",1),
    #"Added Custom" = Table.AddColumn(Custom1, "Таблица13", each if [Столбец1] = "Арматура" then [a] else [b]),
    #"Развернутый элемент Таблица13" = Table.ExpandTableColumn(#"Added Custom", "Таблица13", {"Количество"}, {"Таблица13.Количество"}),
    #"Removed Columns" = Table.RemoveColumns(#"Развернутый элемент Таблица13",{"a", "b"})
in
    #"Removed Columns"

c=List.Buffer(b[Сумма]),d=List.Buffer(b[Наименование])

let a=let a1= (a,b)=>
let b1=List.Generate(()=>[c=a{0},i=0],
each [i]<List.Count(a),
each try if b{[i]}=b{[i]+1} 
then [c=[c]+a{[i]+1},i=[i]+1]
else [c=a{[i]+1},i=[i]+1]
otherwise [i=[i]+1], each [c])
in b1 in a1,
b=Excel.CurrentWorkbook(){[Name="Таблица_1"]}[Content],
c=(b[Сумма]),d=(b[Наименование])
in Table.FromColumns(Table.ToColumns(b)&{a(c, d)},
Table.ColumnNames(b)&{"Кол-во накопительно"})

=ЕСЛИОШИБКА(ИНДЕКС(Лист2!$A$1:$C$1;АГРЕГАТ(15;6;СТОЛБЕЦ($A$1:$C$1)/(A2=Лист2!$A$2:$C$176);1));"")

 Starting portqry.exe -n 1с-serv -e 1434 -p UDP ...


Querying target system called:

 1с-serv

Attempting to resolve name to IP address...


Failed to resolve name to IP address
portqry.exe -n 1с-serv -e 1434 -p UDP exits with return code 0x00000063.
=============================================

 Starting portqry.exe -n 1с-serv -e 1433 -p TCP ...


Querying target system called:

 1с-serv

Attempting to resolve name to IP address...

Failed to resolve name to IP address
portqry.exe -n 1с-serv -e 1433 -p TCP exits with return code 0x00000063.