Richard
Thanks for that it works a treat. May I ask you another question?

From your solution I have been trying to complete it and update the
formula but keep getting stuck.

If I have say a 200 or 400g carton that has a mixture of fruit say:-

e.g. The 200g carton

80 grams of pineapple
40 grams of Kiwi
80 grams of grapes

How would I implement this into a formula?

Hope you can help and once again thanks

Martin


--
AKFRUIT
------------------------------------------------------------------------
AKFRUIT's Profile: http://www.excelforum.com/member.php...o&userid=33796
View this thread: http://www.excelforum.com/showthread...hreadid=535640