I have a column that can have some reoccurring words. I would like to be able to count all the rows in between these cells and have a tally that continually appears at the end of the row.
Ideally have the tally only appear at the end of the last row and keep the tallies of all the rows where the repeat happened.
while I am not against a VBA solution, I would prefer it to be an excel formula solution.
Here is an example of what I would like to be able to do.
Ideally have the tally only appear at the end of the last row and keep the tallies of all the rows where the repeat happened.
while I am not against a VBA solution, I would prefer it to be an excel formula solution.
Here is an example of what I would like to be able to do.
Date | data | data | occurrence word | data | tally |
1/4/23 | trust | ||||
1/8/23 | p-5 | ||||
1/9/23 | w-8 | ||||
1/10/23 | p-5 | ||||
1/11/23 | trust | 3 | |||
1/12/23 | w-8 | ||||
1/15/23 | bms | ||||
1/16/23 | bms | ||||
1/18/23 | p-5 | ||||
1/20/23 | p-5 | ||||
1/22/23 | trust | 5 | |||
1/23/23 | bms | ||||
1/24/23 | trust | 1 | |||
1/28/23 | p-5 | ||||
2/2/23 | p-5 | ||||
2/3/23 | bms | ||||
2/6/23 | p-5 | ||||
2/7/23 | w-8 | 5 | |||
2/8/23 | |||||
2/9/23 | |||||
2/10/23 |