Hi,
I thought this would be easy but I'm stuck.
I'm working with 2 datasets, a longlist and a shortlist. I have a working Match formula that gives me the rows where there's a match. I wanted to nest the Match formula in a Count formula to get the total rows that are < 10.
I'm just working out the formula but I plan on using it in a VBA procedure so I'm looking to avoid helper Col or anything like that. And I am mentioning the fact that I will be throwing this into VBA because maybe I'm doing this the wrong way and there's an easier way. Thanks in advance.
-xlBunny
Bookmarks