Hi,
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
Thanks
Alternative to VBA in E2:*
*...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Please Login or Register to view this content.
Ben Van Johnson
Wow, what a superstar!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks