sum highest 5 values in a table without sort

August 10, 2011 at 01:09:05
Specs: Windows 64
I have a table 6 coluns x 20 rows and need to sum the highest 3 or 4 or 5 values in each column without resorting the table. I have tried copying the data then sorting the data but that has not worked.

See More: sum highest 5 values in a table without sort

Report •


#1
August 10, 2011 at 04:07:45
re: "need to sum the highest 3 or 4 or 5 values in each column"

What do you mean by "3 or 4 or 5"?

Will you making that choice each time you want a SUM? How will you tell Excel how many values to SUM?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question