TomNR
Member
Hi all Excel Masters!
I was wondering if there was a way to count the number of times a value occurs in a table but in a sequenced manner. For instance:
1 - John
2 - John
1 - Adam
1 - Peter
2 - Adam
1 - Peter
3 - John
1 - Richard
1 - Oscar
2 - Richard
4 - John
Thank you all in advance as I am stumped!
I was wondering if there was a way to count the number of times a value occurs in a table but in a sequenced manner. For instance:
1 - John
2 - John
1 - Adam
1 - Peter
2 - Adam
1 - Peter
3 - John
1 - Richard
1 - Oscar
2 - Richard
4 - John
Thank you all in advance as I am stumped!