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 Have Column A Sorted In Ascending Order With Colums B And C
Displaying The Total Number Of Components Associated With That Length. I
Would Like To Program The Columns To Perform The Function.

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=389523

sort ascending on column A and assign Headers to your columns, such as
LENGTH, QUANTITY1, QUANTITY2 in Row 1............
Then use the Data Subtotals feature setting "At each change in " LENGTH
"use function" SUM and check both of the QUANTITY boxes OK...........


Vaya con Dios,
Chuck, CABGx3


"travelersway"
wrote in message
news:travelersway.1slima_1122077104.2337@excelforu m-nospam.com...

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 Have Column A Sorted In Ascending Order With Colums B And C
Displaying The Total Number Of Components Associated With That Length. I
Would Like To Program The Columns To Perform The Function.

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=389523

Thanks Chuck,

That gave me basicly what I asked for. What I'd like to do is have this
performed without doing the operations manually. Is there a way to write
a formulation to accomplish this?

Travelersway


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