talytech
07-11-2019, 01:49 PM
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
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