I have a spreadsheet with over 1,000 rows of information. Two of the columns
contain data such as a name, and a numerical value. I'd like to be able to
extract say, the top twenty values. That would be a simple sort. But I'd
like to take into consideration that certain values in the "name" column may
be repeated throughout the spreadsheet, with various values attached to
them. So, for example, if "smith" were repeated four times, with values of
1000, 2000, 3000 and 4000, those values could be added and combined into one
entry in that top twenty. Is there a way to do this automatically?

Thanks in advance for any help.

Jim

--