populate a column with a value *adjacent* to the max value from a subset

[matthew_swanson]

hi everyone, i have another problem i cant think of a solution to.. could someone please help?

so, let's say i have a dataset like this.. i am trying to figure out how to make a 4th column that contains the value in column 3 from whichever row that has the max value of column 2 grouped by column 1

so i want to take this:

and find a way to make a 4th column that looks like this

i've gotten halfway there. i know how to use the summarize tool to find the max value in column 2 grouped by column 1, but i dont actually care about that max value... i want the value from the column beside it..

[matthew_swanson · Accepted solution]

never mind, i figured it out.. i needed to join the original dataset onto the summary to get the third column value.. and THEN join the summary data onto the original dataset