Forum Discussion
Keep only the rows with highest values in column C when column A and B have equal values
Hello! I have an Excel table like the one below and I want to keep only the rows with highest values in column C when column A and B have equal values and also to keep all the rows that have differe...
There are new functions that may be brought into play as part of the solution algorithm. One such is GROUPBY. If the first two columns are named 'IDs' and the 3rd is 'weightedRatio', the formula
= GROUPBY(IDs, weightedRatio, MAX, , 0)will filter out all the duplicate IDs, returning the maximum weighted ratio for each distinct combination.