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:
<tbody>
</tbody>
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 1 for UNG, since it has been 1 entry since the last Leg for UNG
Thanks so much for the help!
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 |
<tbody>
</tbody>
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 1 for UNG, since it has been 1 entry since the last Leg for UNG
Thanks so much for the help!
