I have a table that looks like this -
| Source Rank | Value |
|---|---|
| 1 | A |
| 2 | A |
| 3 | A |
| 2 | B |
| 3 | B |
| 1 | C |
| 2 | C |
| 3 | C |
I want to make only keep the rows for each value with best rank. So the table will look like this -
| Source Rank | Value |
|---|---|
| 1 | A |
| 2 | B |
| 1 | C |
CodePudding user response：
It's almost impossible to find a better argument for the invention of the "Subtotals" feature, as you can see:
Oh, in case you don't get the same results immediately: don't forget to click the 2 button in the left margin :-)
CodePudding user response：
Create a Pivot Table from the source data, and set:
Row Labels: Value
Values: Source Rank - and use the pulldown to set to Min
Admittedly this will have the columns the other way round from what you show as ideal result.
