Excel Add Qty for Unique Parts?
Excel Add Qty for Unique Parts?
(OP)
Hello.
I'm combine unique names and add the quantities. I use data extraction in AutoCAD to excel and I get all my Parts and qtys.
Column-A = Parts Name
Column-B = Qty for Parts in Column A
Column-C = Parts Name
Column-D = Qty for Parts in Column C
Column-E = Parts Name
Column-F = Qty for Parts in Column E
.... ect up to Column V
See Image:
http://www.homenkobuilders.com/images/parts.png
Basically I want each unique part and its quantity.
I tried using a lookup but I haven't really used it very much and can't get it to work properly.
Any Suggestions?
Thanks
I'm combine unique names and add the quantities. I use data extraction in AutoCAD to excel and I get all my Parts and qtys.
Column-A = Parts Name
Column-B = Qty for Parts in Column A
Column-C = Parts Name
Column-D = Qty for Parts in Column C
Column-E = Parts Name
Column-F = Qty for Parts in Column E
.... ect up to Column V
See Image:
http://www.homenkobuilders.com/images/parts.png
Basically I want each unique part and its quantity.
I tried using a lookup but I haven't really used it very much and can't get it to work properly.
Any Suggestions?
Thanks





RE: Excel Add Qty for Unique Parts?
http://virtualpipeline.spaces.msn.com
RE: Excel Add Qty for Unique Parts?
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Excel Add Qty for Unique Parts?
RE: Excel Add Qty for Unique Parts?
I tried the sumif function but I couldn't get a good way to cycle through all the data when its not in just two columns.