Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count occurrences of values in a column??!!
If I've got a column with lots of different values in, but they can be repeated, eg: Bob Sarah Steve Sarah Sarah Bob Jim etc etc. Is there a way I can split them up by value and count the number of times each value appeared, keeping in mind that the values entered will be different all the time so I can't set a list of values to check through, they could be anything. So say for the list above, I'd want to get the following displayed somewhere for printing: Bob 2 Sarah 3 Steve 1 Jim 1 Any help would be most appreciated!! -- me123 ------------------------------------------------------------------------ me123's Profile: http://www.excelforum.com/member.php...o&userid=34312 View this thread: http://www.excelforum.com/showthread...hreadid=540776 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions |