Quote:
Originally Posted by Ron Rosenfeld[_2_]
On Thu, 12 Jul 2012 09:28:02 -0700, "joeu2004" wrote:
"Ron Rosenfeld" wrote:
On Thu, 12 Jul 2012 07:50:38 -0700, "joeu2004" wrote:
For example, if you have 5 percentages in A1:A5, the largest sum
of any 4 is:
=MAX(SUM(A1:A4),SUM(A1:A3,A5),A1+A2+A4+A5,A1+A3+A4 +A5,SUM(A2:A5))
What am I missing? Wouldn't the largest sum be the sum of the largest?
In other words, why not just =sum(large(data,{1,2,3,4}))
Well, duh! I believe you are right. That's the trouble with homework
assignments: they are often worded in such a way that if we don't think it
through, we find the hardest solution. I guess you get the A+ for this
problem. :-)
I'll post something then for the OP. Thanks.
|
Hi Guy's - Many thanks for your help with this - I agree, this was all about the approach and not over-complicating. The formula works great and I have been able to incorporate this into a simple
VB process to flag values that fail the test.
FYI - Not a homework assignment - This relates to the monitoring of concentration limits for investments in US Life Insurance Regulations!