Hello!
I'm working on a spreadsheet where I have two columns, ID# & Total:
ID # Total
0101 250
0102 137
0103 250
0201 360
0202 124
0203 188
There will be more elements, but what I want to do is to find the two largest totals in the 01xx range and add them together. I want to be able to do this with all ID prefixes (ex. 02xx, 03xx, etc).
I've tried the DMAX function, but I couldn't find a way to do the second largest total. Please keep in mind that there may be duplicate values (as in my example table under 0101 & 0103).
So basically, I need the sum of the two largest totals for each ID group.
Thanks so much!
Richard
Bookmarks