View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monkeytrader monkeytrader is offline
external usenet poster
 
Posts: 16
Default i think i need count function help

i need a function to count how many times a symbol occurs in a list.

example of list of symbols:

abc def ghi jkl mno qxr
qxr mno jkl ghi def abc
abc def ghi jkl mno qxr
abc abc abc abc abc abc

would like to show for example, how many times "abc" occurs, "def", etc.

thanks in advance for your help.