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...
G_M_C I believe the easiest way would be to use Power Query for that. See attached. You familiar with PQ?
- Hello and thank you for your time!
I am not familiar with PQ, but I will try to learn in the future.
I managed to solve the problem with the formulas sugested by our colleagues HansVogelaar and OliverScheurich.
All the best!
