Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Try the Countif function
if the ones of interest are in Column A and the recommendations are in columns C-F Will give you the number of times the initials in Column A is recommended. =countif(C:F,A1) copy down as far as you need. "CRM" wrote: I have a list containing the 3 and 4 letter stock symbols of "buy" recommendations from four different brokers. I want to count the number of times the same stock symbols occur within this list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
count number of occurences within a string | Excel Worksheet Functions | |||
Count occurences between dates | Excel Worksheet Functions |