Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list unique values in a column
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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=518114 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list unique values in a column
Assume values you want to check are in C2:C50, in D2 put
=INDEX($C$2:$C$50,MATCH(0,COUNTIF($D$1:D1,$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 datafilteradvanced 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 "beechum1" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30489 View this thread: http://www.excelforum.com/showthread...hreadid=518114 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
VBA to set AutoFilter to List all rows with same values in column? | Excel Discussion (Misc queries) | |||
Finding Unique Values in Column | Excel Discussion (Misc queries) |