Hello,
I want to dynamically filter out certain keywords that I am getting based from a different input data.
In the above example, I am able to create the CALC column if there is only 1 condition of filtering out keyword C. I use the Contains logic to achieve that.
But now my requirement is that if I get an external file which has all the keywords that need to be filtered out, how do i achieve that?
So for example, since keywords C and D needs to be filtered, I need to create some formula that looks on group 1, filters our C&D and the new column should be 21-3-4==14
| Group | Names | COUNT |
| 1 | A | 1 |
| 1 | B | 2 |
| 1 | C | 3 |
| 1 | D | 4 |
| 1 | E | 5 |
| 1 | F | 6 |
| 1 | TOTAL | 21 |
| 2 | B | 4 |
| 2 | C | 5 |
| 2 | E | 6 |
| 2 | F | 7 |
| 2 | TOTAL | 22 |
