Searching columns, summarizing, and totalling?
 

I have an Excel spreadsheet that my company uses as a "cutbill" to send
to the shop floor for production purposes. One of the columns of this
cutbill contain part numbers from our inventory system.

Typically there are mulitple occurances of a part number with a
quantity formulated for each entry.

At the bottom of the spreadsheet (outside of the print area) I would
like to generate a summarized bill of material. I need Excel to scan a
column of part numbers, generate a "simplified" list of part numbers,
and totalling the "like" occurances.

Our inventory system has a HUGE amount of numbers, and I'm not sure how
to have Excel to search for a "mystery" number. As the part numbers
change with the job, and new numbers are constantly being generated.

What is the easiest way to do this? I'm not an Excel expert, but I can
usually fumble around in there and get it to do what I need it to.

Thanks for any suggestions.
Drew


--
Drew H
------------------------------------------------------------------------
Drew H's Profile: http://www.excelforum.com/member.php...o&userid=37481
View this thread: http://www.excelforum.com/showthread...hreadid=571400

Searching columns, summarizing, and totalling?
 

Drew, I think the easiest way to get your summary is to copy your sheet, sort
based on part number and then use data - subtotals to get the quantity for
each part number. HTH
--
Sincerely, Michael Colvin


"Drew H" wrote:


I have an Excel spreadsheet that my company uses as a "cutbill" to send
to the shop floor for production purposes. One of the columns of this
cutbill contain part numbers from our inventory system.

Typically there are mulitple occurances of a part number with a
quantity formulated for each entry.

At the bottom of the spreadsheet (outside of the print area) I would
like to generate a summarized bill of material. I need Excel to scan a
column of part numbers, generate a "simplified" list of part numbers,
and totalling the "like" occurances.

Our inventory system has a HUGE amount of numbers, and I'm not sure how
to have Excel to search for a "mystery" number. As the part numbers
change with the job, and new numbers are constantly being generated.

What is the easiest way to do this? I'm not an Excel expert, but I can
usually fumble around in there and get it to do what I need it to.

Thanks for any suggestions.
Drew


--
Drew H
------------------------------------------------------------------------
Drew H's Profile: http://www.excelforum.com/member.php...o&userid=37481
View this thread: http://www.excelforum.com/showthread...hreadid=571400