CODEWITHSUNDEEP
sortinggoogle-sheetsindexingmatchvlookup
Aaron Parrilla
Aaron Parrilla

Reputation: 542

Find max value by group in google sheets

Let's assume I have data like this and I'd like to fond the max value on a column an repeat for all the others within the same group: enter image description here

What coul i put on Result as formula to obtain the desired result? Is there a way to obtain this result without ordering the data first?

Upvotes: 0

Views: 702

Answers (1)

player0
player0

Reputation: 1

use:

=INDEX(VLOOKUP(A2:A&B2:B, SORT({A2:A&B2:B, C2:C}, 2, ), 2, ))

enter image description here

Upvotes: 1

Related Questions