| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Counting multiple number entries in a single cell
I need to come up with a formula (e.g., COUNTIF, VLOOKUP) that will look at
each cell in a column and count the number of occurence for each number in all cells in the column. I'm not sure which formula to use or which 'seperator' (i.e., comma, dash, etc.) to use within the cell. My numbers are inclusive of 1 through 43, and I do not want to count the number 1 as number 1 when it appears as 10, 11, 12, 21, 31, 41 and so on. I thank you in advance for any and all assistance, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
| How to sort ascending or descending in multiple entries within one single cell? | Excel Discussion (Misc queries) | |||
| Excel 2003: Autofilter with Multiple Entries | Excel Discussion (Misc queries) | |||
| Counting a single value across multiple cell groups | Excel Discussion (Misc queries) | |||
| Counting number of row entries | Excel Discussion (Misc queries) | |||
Threaded Mode
