Hi Guys,
My question is to filter “AAA” in the Type column, select the min “level” value and get max rev value (7).
I am not familiar with VB code. I am wondering how can I just use one or two sentences to filter the right value for the below table?
Thank you
Type | Level | Rev |
---|---|---|
AAA | 2 | 6 |
BBB | 1 | 4 |
CCC | 1 | 4 |
DDD | 1 | 4 |
AAA | 3 | 5 |
AAA | 4 | 4 |
BBB | 2 | 3 |
DDD | 2 | 7 |
CCC | 2 | 3 |
AAA | 1 | 7 |