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...