find cells that match in column
 

Can someone help me out with this problem? I have a worksheet that has
12 columns.
In clomun F I have part numbers, In column D I have part description,
in Coumn B i have quantity.
I would like to match all of the rows that have the same part # and
description and total all of the quanties and put hte whole row as a
single row with the total quanties.


C D
F
QTY Description Part #
6

find cells that match in column
 

This would be a good opportunity for a Pivot Table. Debra Dalgliesh has
quite a few very good pages on Pivot Tables. Start at
http://www.contextures.com/tiptech.html .


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"rpick60" wrote in message
...
Can someone help me out with this problem? I have a worksheet that has
12 columns.
In clomun F I have part numbers, In column D I have part description,
in Coumn B i have quantity.
I would like to match all of the rows that have the same part # and
description and total all of the quanties and put hte whole row as a
single row with the total quanties.


C D
F
QTY Description Part #
6