00182 Partial Match POWER QUERY

Count rows based on conditions. 0:00 Requirements 0:24 Load Data into Power Query load 3 tables 1:24 Requirement Adjustment ‘lamp’ or ‘lamps’ NOT ‘clamps’ 1:56 Prep text wrap with spaces, text to lowercase 3:34 Merge tables filters 10000 rows to selected state 4:36 Add SearchWord repeat search words beside rows 5:50 Search words found? function Text.PositionOf 6:39 Filter out rows if search words not found remove rows 7:26 Export rows to Excel sheet 7:44 Create Row Count query group by query counts rows 9:11 Export Row Count query to Excel sheet In a previous post I used formulas to solve this: https://www.myspreadsheetlab.com/part...