View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curly Worly Curly Worly is offline
external usenet poster
 
Posts: 1
Default 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