Nov 09 2022 04:40 AM
Hi,
How to code and use "RemoveMatchingRows" in Excel Power Query to remove complete rows from a table based on checking if cells' values in 2 or columns of this row are blanks, null, or empty, yet the 3rd column's cell contains data.
I checked the Mircosoft learning site for example, but the given one is very straight forward and not providing much help.
To illustrate what is needed, see below
Nov 09 2022 08:22 AM
Nov 09 2022 08:53 PM
Nov 10 2022 01:51 AM
This is the easiest suggestion i can give if you want to apply Power Query along with the Table.RemoveMatchingRows function. If you work with Office 365 or Excel 2021 you can alternatively try the LET and FILTER function. However this would be a possible solution without Power Query and without the Table.RemoveMatchingRows function.
=LET(result,FILTER(A2:C24,(A2:A24<>"")*((B2:B24="")+(C2:C24=""))),IF(result=0,"",result))
If you work with Excel 2013 or Excel 2016 an alternative could be Advanced Filter.