I am trying to find the first repeating max value and print the value that is next to the max value. Here is what I am trying to do.
A B
1 5
2 5
3 6
4 6
5 6
The bolder values are what I want to focus on. I want to find the max value of column B and print the value from column A to some other cell. I tried this function:
{=MAX((B2:B181=G3)*A2:A181)}
But I get the last value of column A which is 5 instead of the value that I want which is 3. What am I doing wrong?
A B
1 5
2 5
3 6
4 6
5 6
The bolder values are what I want to focus on. I want to find the max value of column B and print the value from column A to some other cell. I tried this function:
{=MAX((B2:B181=G3)*A2:A181)}
But I get the last value of column A which is 5 instead of the value that I want which is 3. What am I doing wrong?