PQ/M working with list syntax - List.RemoveItems with criteria

Good day steve-m

The function List.RemoveMatchingItems may help solve this.

1. I created a table in Excel with a column called "Activity". It contained some items starting with "Rev" and others not starting with "Rev". The table was called "Table1".
2. The first parameter of List.RemoveMatchingItems is a list - in this example the "Activity" column.
3. The second parameter is a list of items you want to remove...
4. ...the third parameter of the example says - keep each item not beginning with "Rev".

Here is the M code.

let
   Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
   #"Remove Rev Rows" = List.RemoveMatchingItems(
      Source[Activity],
      {"Rev"},
      each Text.Start(_,3) <> "Rev"
   )
in
   #"Remove Rev Rows"

 Here are the results of the "Source" step and the "Remove Rev Rows" step.