Can you just create a pivot table from your data? Click a single cell in
your table, then Data Pivot Table. Follow the prompts... when you get to
Layout, drag Diameter then Length into the Row fields and Qty into the Data
area (be sure it says 'Sum of Qty'; if not, double-click on 'Count of Qty'
and select Sum). After it's finished, you may want to clean it up a bit:
right-click on the first diameter's subtotal (eg: 3/8 Total), select Field
Settings and choose 'None' under subtotals.

One caveat with Pivots tables: they won't automatically change when the
underlying data is updated. To update the pivot table, right-click in the
pivot table and select Refresh Data.

"BillyBoy" wrote:

I have a List of values in Three Columns and countless rows.
Example:
Col A(QNTY) Col B(Dia.) Col C(Length)
Row1 10 3/4 2
Row2 5 3/4 1 1/2
Row3 7 3/8 2
Row4 21 3/8 1 1/2
Row5 6 3/4 1 1/2
Row6 0 "" ""
Row7 5 3/8 1 1/2

I need to create a list that combines the cells that are the same in Col's B
& C and Totals.

Example:
Col A(QNTY) Col B(Dia.) Col C(Length)
Row1 10 3/4 2
Row2 11 3/4 1 1/2
Row3 7 3/8 2
Row4 26 3/8 1 1/2

I am kinda new to using Excel and don't know a lot about it but I am trying
to learn...
Thanks, In advance