| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count a number in a range with cells containing more than one numb
I've got a range (one column) where each cell either
- has no value or number in it (empty cell) - has 1 or more values in it (and I can separate by , ; - / or any other symbol. ) Cells only have numbers, no text. Numbers are 1 to 8. I would like to know how many occurances of each number happen in that range. Using count function does not work clearly (or any other count function). For instance: A1: 1,5 A2: A3: 8 A4: 2,4,6,7, etc... Anyone knows if there is an existing function within excel or needs to be macro (not my forté)? Many thanks to the this community... Peter C. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of cells containing a date within a range | Excel Discussion (Misc queries) | |||
| Count the number of cells that conatin a "." in a range | Excel Worksheet Functions | |||
| Count cells in column that contain number in a range | Excel Worksheet Functions | |||
| how do I count the number of gray-shaded cells within a range? | Excel Worksheet Functions | |||
| count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
Threaded Mode
