How to use Excel for comprehensive material statistics
Thread Content
The installation materials for each pipe have been counted, but how can the comprehensive materials be quickly categorized and counted using Excel?
It can be categorized using different sorting methods by column, and then summed up.
Try categorizing and summarizing it. There are also modern 3D software programs that automatically generate material lists for each individual wire
The sofa is right; it’s possible to sort by different columns (specifications, materials) for categorization, and then sum them up.
After categorizing and summarizing, adjust the format; the most tedious part is creating the pipeline detail sheet manually.
VBA can be used to automatically summarize and total