Max from column of repeating numbers
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.
where A1:A16 contains the counts in ascending order and B1:B16 contain the names...
you can replace the name in the formula with a cell reference containing the name.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1