Counting the Frequency of an Item in a List

[rtb2399]

I am using Excel 2007 and I have multiple coloumns of data that each have stock tickers in them and I need to return the frequency of how often each item appears. Is there any easy way where I can make a list of all the data and get a count of how often the information appears in the column next to it?

Please let me know if you need more information.

Thanks in advance

 

[Sahak]

Hi Rtb2399:

I need to return the frequency of how often each item appears

Do you mean how many times (quantity) ?

 

[rtb2399]

Yes quantity of a number of times an item is listed in a matrix

 

[Sahak]

I’m not sure about matrix but this maybe will give you some idea


Let say your item list is in range A2:A25 & your data in E2:M40
Formula in B2

 =COUNTIF($E$2:$M$40,$A2)

Formula in B3

 =COUNTIF($E$2:$M$40,$A3)

& copy down until B25