Maximum value by ID return in excel
I'm trying to only use the maximum value among IDs in my final table.
Ie:
I have data like this:
ID VALUE
1 237
1 255
2 365
2 322
2 209
3 113
and I want to return this:
ID VALUE
1 255
2 365
3 113
No comments:
Post a Comment