I've been wrecking my brain for 2 days trying to figure out how to return the number of rows based on a value in another column. For an example, in the sample table I want to count the total rows in STC where the MCode is "BB".
I should return 2 for "BB" and 2 for "BS". I can't seem to figure out the best VBA approach to do this. Any help is appreciated.
STC MCode 140 BB 250 BB 360 BS 500 BS