lbs ounces grams

[mjc]

hi all
please can anyone help me.i'm trying to sort 3 weights in lbs
ounces grams. all i need help with is for excel to pick the two biggest
weights and
add them together and put answer in a5 lbs b5 ounces c5 drams,
sample below.

a1 lbs b1 oz c1 dr
a2 4 7 8
a3 5 8 8
a4 4 8 8

a5 b5 c5
for answer

thanks in advance of a good result,

 

[mphell0]

Put this in A5

=MAX(A2:A4)+LARGE(A2:A4,2)

and then copy to columns B and C.

Note: the 2 in the LARGE function denotes the second largest number.
You
can put 3 for the third largest, 4 for the fourth largest...

 

[mjc]

thanks mphell
i will try it thanks

 

[mjc]

thanks mphello
i will try it thanks

 

[vezerid]

This is a problem similar to time problems. I am not entirely familiar
with this system, but I think it is 16 oz to a pound and ca. 29 grams
to an ounce.

So we need to convert each weight to the smallest denomination, grams,
take the largest two of the total grams and add them. We can do this in
cell D5 with the *array* formula:

=SUM(LARGE(A2:A4*464+B2:B4*29+C2:C4,{1,2}))

As an array formula, this needs key combo Shift+Ctrl+Enter to commit.

Then, the formula for A5 (pounds) is;

=INT(D5/464)

The formula for B5 (oz) is:

=MOD((D5-C5)/29,16)

And the formula for C5 (grams) is:

=MOD(D5,29)

Explanation: 464 is 16*29. The exact content in grams of an ounce is
not so important for ordering purposes, but it could be if you add two
grams quantities in excess of an oz. So if you want replace 29 with the
exact number and 464 with 16*this number.

HTH
Kostis Vezerides

 

[mjc]

i think i put grams instead of drams.sorry. 16 oz lb 16 drams to oz.i
will try it anyway thanks .mjc

 

[mjc]

That Would Not Work But This Might Be Clearer To What I Want,
A1 Lb B1 Oz C1 Drams

A2 7 B2 8 C2 8
A3 8 B3 7 C3 8 3 Random Weights
A4 6 B4 5 C5 8

A5 B5 C5 Answer

I Want Excel To Find The 2 Biggest Weights And Put Answer In A5.b5.c5
Or Can I Color The Biggest Weights Say Red And Get Excel To
To Add Them .and Put Answer In