| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excell: count occurance of letters in a column
I would like to have Excell count an occurance of letters in a column, like
subtotal only without splitting the data, simply give a total of occurances of a letter in the column. Can this be done? |
|
#2
|
|||
|
|||
|
Yes this is possible
Use this array formula, use CTRL-SHIFT-ENTER instead of ENTER for the letter a =SUM(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a",""))) More info about them you can find here http://www.cpearson.com/excel/array.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ispencer" wrote in message ... I would like to have Excell count an occurance of letters in a column, like subtotal only without splitting the data, simply give a total of occurances of a letter in the column. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | 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 | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
Linear Mode
