i think i need count function help

M

monkeytrader

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.
 
P

Peo Sjoblom

=COUNTIF(A1:F100,H1)

where H1 holds the value you want to count

adapt to fit your real data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top