Hello, I know that from the title this may sound like a redundant post but I have not been able to find a solution that fits my problem, yet. I have a data set that hierarchically arranged such that there are lots of repeating values as one moves from the left most column right like in the following schematic:

a b d

a b e

a c f

The problem I have is as follows. I have a three columned dataset where, for every unique (repeating) value in column one, I need the entire row of values that corresponds to the maximum in column three (the question will become more clear when looking at the dataset.) A simple diagram that hopefully illustrates this problem is below where the idealized data set is on the left and the output I'm looking for on the right:

10-4-15 10-6-50

10-5-35 20-8-60

10-6-50

20-7-15

20-8-60

20-9-25

As in the example above, in the real dataset the numbers in the third column sum to 100 (percentages...). So, just to be as clear as I can, for every unique value in the first column, I need to choose the maximum value in column three and return the entire corresponding row. I need to keep the row together as columns one and two are used to link other tables together in a database. I hope this description of the problem made sense, I'm sure its clearer with the actual data. Thanks, SRF

Excel_Help.xlsx

a b d

a b e

a c f

The problem I have is as follows. I have a three columned dataset where, for every unique (repeating) value in column one, I need the entire row of values that corresponds to the maximum in column three (the question will become more clear when looking at the dataset.) A simple diagram that hopefully illustrates this problem is below where the idealized data set is on the left and the output I'm looking for on the right:

10-4-15 10-6-50

10-5-35 20-8-60

10-6-50

20-7-15

20-8-60

20-9-25

As in the example above, in the real dataset the numbers in the third column sum to 100 (percentages...). So, just to be as clear as I can, for every unique value in the first column, I need to choose the maximum value in column three and return the entire corresponding row. I need to keep the row together as columns one and two are used to link other tables together in a database. I hope this description of the problem made sense, I'm sure its clearer with the actual data. Thanks, SRF

Excel_Help.xlsx

## Comment