Hello Wonderful Helpers,
I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale.
For example:
<colgroup><col><col></colgroup><tbody>
</tbody>
You all are amazing! Thank you so much for your help.
I'm wondering if there is a formula that can count until a leading cell changes content. When the cell changes it starts back at 1?? I need to do this on a large scale.
For example:
| Fox | 1 |
| Fox | 2 |
| Dog | 1 |
| Cat | 1 |
| Cat | 2 |
| Cat | 3 |
| Cat | 4 |
| Mouse | 1 |
| Bird | 1 |
| Bird | 2 |
| Horse | 1 |
| Chicken | 1 |
| Chicken | 2 |
| Chicken | 3 |
| Fish | 1 |
<colgroup><col><col></colgroup><tbody>
</tbody>
You all are amazing! Thank you so much for your help.
