Quote:
Originally Posted by Spencer101
Hi,
Two quick questions need to be answered to be able to reply with a helpful answer.
1) Could any of the percent figured be repeated?
2) Are the percentages whole numbers (1%, 5% 17%) or decimal pointed (1.7%, 3.3%, 22.95732%)?
EDIT: Actually three questions as I just noticed you also posted this in the "Excel Programming" section - 3) Are you looking for a VBA approach to this or a formulaic one?
|
OK - So I feel completely silly - It was pointed out to me that the ANY two values is irrelevant as you only need to consider the two highes values...
The solution presented is this (and it works just fine):
=sum(large(data,{1,2,3,4}))
Many thanks for your help though!
Similar Threads
Hybrid Mode
