Friday, 27 September 2013

Maximum value by ID return in excel

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