Hi,

to generate a list of unique part name select the column with the part names
and choose Data, Filter, Advanced Filter, choose Copy to another location,
make sure the List range is your column of names, in the Copy to box enter
the cell address where you have room for the output, check Unique records
only and click OK.

Beside each result enter the following formula
=COUNTIF(D$1:D$1000,J2)

where J2 is the first output cell from the Advanced Filter and D1:D1000 is
the range with the names. Copy the above formula down.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"cncrouterman" wrote:

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