Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Totalling occurances in a column
hi,
im looking for a way to give totals of the number of occurances of strings in a column. the column i have has a set range of possible string values (which can be referenced in a seperate sheet) and im looking for a way to produce a table which shows how many times each of these occurances happens. i have about 6 columns that i need totals on, each has a seperate column on a seperate sheet with the values. (the list is a history of which selection is made on a cell which has data validation based upon the seperate list). every time one of the cells is changed, the user runs a macro which records each selection into the history sheet. thanks uzusan |
#2
|
|||
|
|||
This seems like a job for Pivot tables to me. See
http://www.contextures.com/xlPivot01.html -- HTH Bob Phillips "uzusan" wrote in message oups.com... hi, im looking for a way to give totals of the number of occurances of strings in a column. the column i have has a set range of possible string values (which can be referenced in a seperate sheet) and im looking for a way to produce a table which shows how many times each of these occurances happens. i have about 6 columns that i need totals on, each has a seperate column on a seperate sheet with the values. (the list is a history of which selection is made on a cell which has data validation based upon the seperate list). every time one of the cells is changed, the user runs a macro which records each selection into the history sheet. thanks uzusan |
#3
|
|||
|
|||
thanks for that, i got it working perfectly.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |