You may? find
Datasubtotals
to be helpful

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cncrouterman" wrote in message
...
I have a spreadsheet with data for cabinets for a job. The data includes
type, height, width, length, etc.

I have created additional columns, one for each unique part.
The cabinets are listed vertically, data defining each cabinet
horizontally,
with my added columns tacked on.
Each unique part has its name generated by some of the defining data
So,
34h x 32w x 24deep base cabinet with unfinished ends would generate a name
for a left side base end of
END-L-34h24d-B-DS

So, with a hundred or so rows, and perhaps a dozen or more unique base end
left parts, I want to do two thing, 1 list each unique part name, and 2
count
(display) how many of those parts there are. These two goals apply to the
other parts as well, but I figure it will be simple to copy the solution
to
the other columns