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,


--
mjc
------------------------------------------------------------------------
mjc's Profile: http://www.excelforum.com/member.php...o&userid=34021
View this thread: http://www.excelforum.com/showthread...hreadid=537826