| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count # of instances in cell (a b a) answer 2 formula if possible
I can't get the count of the number of intances of a value to work.
ex: In single cell (a b a) answer=2 for "a", but does not work with any formula I have tried. =countif(data, "*"&text&"*") brings an answer of 0. I was wondering if anyone knows how or if it is possbile to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Formula to count Cell colour. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Threaded Mode
