let
    from = List.Buffer(Excel.CurrentWorkbook(){[Name="Таблица7"]}[Content][Значение]),
    a = List.Max(from),
    b = List.Transform(from,(x)=>[Значение=x,Макс=a]),
    to = Table.FromRecords(b)
in
    to

=НАИБОЛЬШИЙ($F$2:$F$9*($E$2:$E$9=B2);СЧЁТЕСЛИ($B$1:B2;B2))

=МИН(ЕСЛИ($H$4:$H$23*($A$4:$A$23=M18)*($B$4:$G$23>=M19)*($B$1:$G$1=ПРОСМОТР(M17;$A$1:$F$1;$B$1:$G$1));$H$4:$H$23;""))

=ОТБР(E3)

=LET(x;ИНДЕКС($B$4:$G$23;;ПОИСКПОЗ(M17;$B$1:$G$1;1)+1)*($A$4:$A$23=M18);ИНДЕКС($H$4:$H$23;ПОИСКПОЗ(МИН(ЕСЛИ(x>M19;x;""));x;)))

 =ИНДЕКС($H$4:$H$23;ПОИСКПОЗ(МИН(ЕСЛИ(ИНДЕКС($B$4:$G$23;;ПОИСКПОЗ(M17;$B$1:$G$1;1)+1)*($A$4:$A$23=M18)>M19;ИНДЕКС($B$4:$G$23;;ПОИСКПОЗ(M17;$B$1:$G$1;1)+1)*($A$4:$A$23=M18);""));ИНДЕКС($B$4:$G$23;;ПОИСКПОЗ(M17;$B$1:$G$1;1)+1)*($A$4:$A$23=M18);))

let
    from = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    comb = Table.CombineColumns(from,{"Продажа","Категрия"},(x)=>x{0}/x{1},"Продажа"),
    trnsf = Table.TransformColumns(comb,{"Манагер", each Text.Split(_,"/")}),
    to = Table.ExpandListColumn(trnsf, "Манагер")
in
    to

=СУММПРОИЗВ($E$2:$E$92*($A$2:$A$92=M114)*($C$2:$C$92=$N$96)*ЕНД(ПОИСКПОЗ($Q$2:$Q$92;{"2a";"2b";"D"};)))

If oCell.Font.Bold

=ОКРУГЛ(A8*НАКЛОН(C3:C4;A3:A4)+ОТРЕЗОК(C3:C4;A3:A4);0)

let
    from = Excel.CurrentWorkbook(){[Name="Таблица2"]}[Content],
    f=(x)=>[    a = x{0}, 
                b = List.PositionOf(Record.ToList(a),null,Occurrence.Last,(s,c)=>c<>s),
                c = Table.FromRecords({Record.TransformFields(a,{Table.ColumnNames(x){b},(x)=>null})})][c],
    to = f(from)
in 
    to

=B1*(2,5+0,5*(B1>5500))

 =$G$7*СРЗНАЧ($C$3:$C$5)-СРЗНАЧ($D$3:$D$5)

=ЕСЛИ(И(A1="";B1="";C1="");"";A1+B1+C1)