list unique values in a column

[beechum1]

in column C i have part #'s. In column L I want to list the unique
values of Column C and in column M I want to list the # of instances of
each unique value. I did a search and tried a few different formulas i
found, changed the values as I thought necessary, and didn't get any of
them to work for me.

any links or pros that can code that for me real quick??

 

[Peo Sjoblom]

Assume values you want to check are in C2:C50, in D2 put

=INDEX($C$2:$C$50,MATCH(0,COUNTIF($D$11,$C$2:$C$50),0))

enter the formula with ctrl + shift & enter, if done correctly it will wrap
it in curly braces
now copy down until you get an error (#N/A),
In E2 put

=COUNTIF($C$2:$C$50,D2)

copy down to the last non error value in D will give you the count of each
unique value
Having said that, you might as well use data>filter>advanced filter, copy to
another location
unique records only, then use the countif formula on the filtered list

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon