# Max from column of repeating numbers

1. ## 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.

Thanks.

2. Try:

=LOOKUP(2,1/(B1:B16="Bob Smith"),A1:A16)

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.

3. worked great, thx

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1