Forum Discussion
Extracting table values if values in two columns have identical values in other rows
Hi guys, Can someone please help me with a formula for the following task? I have over 40,000 rows of data in 'Table 1', I've extracted a sample. I need to analyse only cells which con...
LachlanB98 I would prefer to tackle such a task with Power Query as demonstrated in the attached workbook. No complicated worksheet formulas needed.
Note that I identified two additional items that should be included from your example, applying consistent logic.