= Table.AddColumn(Источник, "Список", each 
let
 Start_ = [От], 
 End_ = [До],
 GeneratedList = List.Generate(()=>Start_, each _ <= End_, each _ +1)
in
 GeneratedList)

    AddColumn = Table.AddColumn(ПредыдущийШаг, "Test", each 
        let
            a=Table.FromRows(List.Zip({Table.ColumnNames(ПредыдущийШаг),Record.FieldValues(_),List.Skip(Record.FieldValues(_))})),
            b="Искомое Значение" ,
            c=if List.Sum(Table.SelectRows(Table.TransformColumnTypes(a,{{"Column1", type text},{"Column2", type text}}),each Text.Contains([Column1], "Подар") and Text.Contains([Column2],b))[Column3])=null then 0 else
              List.Sum(Table.SelectRows(Table.TransformColumnTypes(a,{{"Column1", type text},{"Column2", type text}}),each Text.Contains([Column1], "Подар") and Text.Contains([Column2],b))[Column3]),

        in 
            с),

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.Profile(Source),
    #"Added Custom" = Table.AddColumn(Custom1, "Custom", each [Count]=[NullCount]),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = true)),
    Custom2 = Table.RemoveColumns(Source,#"Filtered Rows"[Column])
in
    Custom2

</li></ol></fieldset><fieldset class="actions"><ol><li class="action input_action " id="admin_user_submit_action"><input type="submit" name="commit" value="Обновить Пользователь" data-disable-with="Обновить Пользователь" /></li><li class="cancel"><a href="/admin/admin_users/135">Отмена</a></li></ol></fieldset></form>          </div>