I'm looking help with some VBA which will find the last occurrence of value in a column and count cells below that. I've attached sheet which will hopefully explain things better.
Using the attached file...
Column A lists either W, D or L
I would like to search for each of these values one at time starting from the bottom up (in other words, find the last occurrence) then count how many entries are below that point.
Any help, advice or ideas would be great :D