let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Replaced Value" = Table.ReplaceValue(Source," ","",Replacer.ReplaceText,{"ТЕКСТ"}),
    #"Split Column by Position" = Table.SplitColumn(#"Replaced Value", "ТЕКСТ", Splitter.SplitTextByRepeatedLengths(1), {"ТЕКСТ.1", "ТЕКСТ.2", "ТЕКСТ.3", "ТЕКСТ.4", "ТЕКСТ.5", "ТЕКСТ.6", "ТЕКСТ.7", "ТЕКСТ.8", "ТЕКСТ.9", "ТЕКСТ.10", "ТЕКСТ.11", "ТЕКСТ.12", "ТЕКСТ.13"})
in
    #"Split Column by Position"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Column2] = "открыт")),
    #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Column1"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
    #"Grouped Rows"

=SUMPRODUCT(--(DAY(A2:A100)=DAY(TODAY()))*(MONTH(A2:A100)=MONTH(TODAY())))

=SUMPRODUCT(--(E15:E218<>0))

let
    Source = Excel.CurrentWorkbook(){[Name="пример"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"столбец1", type text}, {"дата1", Int64.Type}, {"дата2", Int64.Type}, {"дата3", Int64.Type}, {"дата4", Int64.Type}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type",null,0,Replacer.ReplaceValue,{"дата1", "дата2", "дата3", "дата4"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Replaced Value", {"столбец1"}, "Attribute", "Value"),
    #"Sorted Rows" = Table.Sort(#"Unpivoted Other Columns",{{"столбец1", Order.Ascending}, {"Attribute", Order.Ascending}})
in
    #"Sorted Rows"

let    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Столбец1", type date}})
in
    #"Changed Type"

=PERCENTILE.EXC(B2:B9;PERCENTRANK.EXC(A2:A9;E2;ROWS($A$3:$A$9)))

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Артикул", Int64.Type}, {"Номенклатура", type text}, {"Признак", Int64.Type}, {"Цена", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Признак", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Признак", type text}}, "lt-LT")[Признак]), "Признак", "Цена")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Transposed Table" = Table.Transpose(Source),
    #"Added Index" = Table.AddIndexColumn(#"Transposed Table", "Index", 0, 1),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Index", {"Index"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Index", "Attribute"})
in
    #"Removed Columns"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", Int64.Type}, {"Column3", Int64.Type}, {"Column4", Int64.Type}, {"Column5", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Column1", "Column2", "Column3", "Column4"}, {{"Count", each _, type table [Column1=number, Column2=number, Column3=number, Column4=number, Column5=number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column5", "Index"}, {"Custom.Column5", "Custom.Index"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Expanded Custom", {{"Custom.Index", type text}}, "lt-LT")[Custom.Index]), "Custom.Index", "Custom.Column5")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}, {"Column1.3", type text}, {"Column1.4", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1.1", "Column1.2", "Column1.3"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([Column1.4] <> null)),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Filtered Rows", "Column1.4", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Column1.4.1", "Column1.4.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Column1.4.1", type text}, {"Column1.4.2", type text}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Changed Type1",{"Column1.4.1"}),
    #"Replaced Value" = Table.ReplaceValue(#"Removed Columns1","#","",Replacer.ReplaceText,{"Column1.4.2"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","</a>","",Replacer.ReplaceText,{"Column1.4.2"}),
    #"Split Column by Delimiter2" = Table.SplitColumn(#"Replaced Value1", "Column1.4.2", Splitter.SplitTextByDelimiter(";>", QuoteStyle.Csv), {"Column1.4.2.1", "Column1.4.2.2"}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Column1.4.2.1", type text}, {"Column1.4.2.2", type text}})
in
    #"Changed Type2"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}, {"иванов", Int64.Type}, {"петров", Int64.Type}, {"сидоров", Int64.Type}, {"кошкин", Int64.Type}, {"собачкин", Int64.Type}, {"остаток", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Column1", "остаток"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Column1", "Value", "остаток", "Attribute"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Value", "Массаа"}, {"Attribute", "Исполнитель"}, {"Column1", "Дата"}})
in
    #"Renamed Columns"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Duplicated Column" = Table.DuplicateColumn(Source, "Column1", "Column1 - Copy"),
    #"Extracted First Characters" = Table.TransformColumns(#"Duplicated Column", {{"Column1 - Copy", each Text.Start(_, 2), type text}}),
    #"Grouped Rows" = Table.Group(#"Extracted First Characters", {"Column1 - Copy"}, {{"Count", each _, type table [Column1=text, #"Column1 - Copy"=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Column1", "Index"}, {"Custom.Column1", "Custom.Index"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Count"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[#"Column1 - Copy"]), "Column1 - Copy", "Custom.Column1"),
    #"Removed Columns1" = Table.RemoveColumns(#"Pivoted Column",{"Custom.Index"})
in
    #"Removed Columns1"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type number}, {"Column2", type number}, {"Column3", type number}, {"Column4", type number}, {"Column5", type number}, {"Column6", type number}, {"Column7", type number}, {"Column8", type number}, {"Column9", type number}, {"Column10", type number}, {"Column11", type number}, {"Column12", type number}, {"Column13", type number}, {"Column14", type number}, {"Column15", type number}, {"Column16", type number}, {"Column17", type number}, {"Column18", type number}, {"Column19", type number}, {"Column20", type number}, {"Column21", type number}, {"Column22", type number}, {"Column23", type number}, {"Column24", type number}})
in
    #"Changed Type"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ФИО", type text}, {"Дата", type date}, {"Рейс", type text}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Changed Type", {{"Дата", type text}}, "lt-LT"), List.Distinct(Table.TransformColumnTypes(#"Changed Type", {{"Дата", type text}}, "lt-LT")[Дата]), "Дата", "Рейс")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Набор значений", type text}}),
    #"Inserted Text Before Delimiter" = Table.AddColumn(#"Changed Type", "Text Before Delimiter", each Text.BeforeDelimiter([Набор значений], ".", 2), type text),
    #"Removed Columns" = Table.RemoveColumns(#"Inserted Text Before Delimiter",{"Набор значений"})
in
    #"Removed Columns"

=IFERROR(INDEX(B$2:B$6;AGGREGATE(15;6;ROW($1:$200)/(A$2:A$6=A13);COUNTIF(A$13:A13;A$2:A$3500)));"")

let
    Источник = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Inserted Text Between Delimiters" = Table.AddColumn(Источник, "Text Between Delimiters", each Text.BetweenDelimiters([Файл], "л", "."), type text),
    #"Merged Columns" = Table.CombineColumns(#"Inserted Text Between Delimiters",{"Тип ", "Text Between Delimiters"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged"),
    #"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[Merged]), "Merged", "Файл")
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each not Text.Contains([Column2], "*")),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Column2", Order.Ascending}})
in
    #"Sorted Rows"

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Подразделение", type text}, {"Ф.И.О.", type text}, {"Должность", type text}, {"Вид обучения", type text}, {"Дата обучения", type date}, {"№ протокола", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[#"Вид обучения"]), "Вид обучения", "Дата обучения", List.Max),
    #"Removed Columns" = Table.RemoveColumns(#"Pivoted Column",{"№ протокола"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Подразделение", "Ф.И.О.", "Должность"}, {{"Программа Б", each List.Max([Программа Б]), type date}, {"Программа В", each List.Max([Программа В]), type date}, {"Оазание ППП", each List.Max([Оказание ППП]), type date}, {"СИЗ", each List.Max([СИЗ]), type date}})
in
    #"Grouped Rows"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Column1], "марка")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column3"}),
    #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Column1", Order.Ascending}})
in
    #"Sorted Rows"