Building on a Popular Technique
Last week’s post on “CONTAINSX” proved to be quite popular. In the comments, Sasha provided an alternate formula that used FILTER instead of SUMX. Honestly I have a been of a “fetish” for SUMX – after all it IS the 5-Point Palm Exploding Function Technique – so at first I was like “nice work Sasha but I’m sticking with my SUMX.”
But then “en” asked if we could write a formula that reported what the matching keyword actually WAS – not just whether there WAS a match.
And then, Sasha’s formula came in super-handy. A couple of quick mods and we were in business. Read on for the formula, but first, a quick aside.
Another thing that is easier in Power Pivot than “Traditional” Excel
I really enjoyed the comments (and the emails) we received about the CONTAINSX post. Here are two of my faves: