Pivot Table sorting

Copper Contributor

I have a table with calculated fields that create a parts list for fabrication.  While it is effective at automating this task, I would like to create a summary for the parts that combine quantities of parts of the same width and  length.

this is a screen shot of the table with some data.  Any help would be appreciated.  thanks

parts table.png

1 Reply

@DONLITZ 

 

You may be able to accomplish this with the FILTER function as well, if you have the most current version of Excel. Here's an instructive video on that function.

https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, but were limited to power users. With Dynamic Arrays we have rebuilt the calc engine, effectively turning all formulas into array formulas ...