software

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??--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=518114Assume 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 amp; 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 datagt;filtergt;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

quot;beechum1quot; gt; wrote in
message ...
gt;
gt; in column C i have part #'s. In column L I want to list the unique
gt; values of Column C and in column M I want to list the # of instances of
gt; each unique value. I did a search and tried a few different formulas i
gt; found, changed the values as I thought necessary, and didn't get any of
gt; them to work for me.
gt;
gt; any links or pros that can code that for me real quick??
gt;
gt;
gt; --
gt; beechum1
gt; ------------------------------------------------------------------------
gt; beechum1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30489
gt; View this thread: www.excelforum.com/showthread...hreadid=518114
gt;