Forum Discussion
Working on project that requires me to filter rows blank rows
Thank you, but you may be over estimating my knowledge of Excel. How could I use the list of 100 leads to create a filter for the Value column?
My understanding you need to filter one table on values which do exist in another table, but not in first one. That's the opposite to "filter by name" task.
Let try another way, perhaps it'll be more suitable for you.
Let assume we have table1 with leads and names, table2 with all names and "green" is what we'd like to receive.
Query table 1 and table2. To start with green table in power query right click on first query and Reference. Here Add Custom Column as
Expand AllNames column and add another Custom column as
Group By on these two columns with Sum aggregation of Custom column
Filter Count column keeping zeroes and after that remove this column
Group By first column using as aggregation Sum of Name.1
We will receive errors, for proper result we shall replace in formula bar this part
on
You may check steps in attached file.