Hello! I have a Table just like the one above. I want to count the number of cells in the column Leg since the last entry, given a certain classification on the column Type.
For example, for the type KFT only, how many blank entries are there in the column Legendary since the last entry for Leg?
I know how to solve this issue creating helper columns. But given that I have too many types, I would have to create a helper column for each type, making my table too big given the amount of rows I have. Is there any way I can create a VBA function to perform this task for me, such that I only need one cell per type to let me know the amount of blank cells since last Leg entry for each type? Here is a short example of how my table looks, using only 2 types:
# Type Com Rar Ep Leg
1 MSG 4 1
2 UNG 3 2 1
3 UNG 4 1
4 MSG 3 1 1
5 UNG 4 1
6 UNG 4 1
7 MSG 3 1 1
In this example, I need a formula with output 0 for MSG, since it has been 0 entries since the last Leg for MSG, and output 2 for UNG, since it has been 2 entries since the last Leg for UNG
Thanks so much for the help!
Bookmarks