Column A Is A Group Of Lengths, Many Are The Same Length
Column B Indicates Components Of That Length
Column C Indicates Different Components Of That Length

A B C
8 2 1
7 2 0
8 3 1
6 2 2
8 1 1
7 1 1

I'd Like To enter data in Columns A ,B,C. I would like to have Column E
display all the lengths from Column A (only once) in assending order. I
would like Column F to represent the sum of all component for that
length from Column B and
Column G to represent the sum of all components for that length from
Column C.

Can this be written in a formula of some type with NO MANUAL functions
so Columns E, F, G will automatically come out in this format?

E F G
6 2 2
7 3 1
8 6 3

Any Help Would Be Appreciated.

Thanks,
Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=389628