I have a spreadsheet that contains two columns. This is a sheet of the work items done by a person in a certain amount of time. As of now it looks something like this...
1 Bob Smith
2 Bob Smith
3 Bob Smith
4 Bob Smith
5 Bob Smith
6 Bob Smith
7 Bob Smith
1 Jane Doe
2 Jane Doe
3 Jane Doe
4 Jane Doe
5 Jane Doe
1 Blah Moe
2 Blah Moe
3 Blah Moe
4 Blah Moe
If you look at the first column you can see that is just a count and when the name in the second column changes, the count starts over.
What I am trying to do is find the max count for each person. So, for Bob it would be 7, Jane 5 and so on...
Is there a formula I can use to extrapolate this? I tried a few things but wasn't able to get it to work. I need to end up at a point where I have a name and a number I can use in a chart.
Thanks.
Bookmarks