| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create count formula for two items in same cell
I am trying to count the number of times a particular set of letters (a
persons name abreviated) appears in a cell. I am using the count function. However a particular cell has two sets of abreviated letters (JRD / GB). How do I get the formula to recognise that both items need to be counted independently, as normal "countif" is not recognising anything in the cell at all |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Formula to count month-specific items | Excel Discussion (Misc queries) | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| How do I set up a formula to count multiple items? | Excel Worksheet Functions | |||
Threaded Mode
