Counting number of occurences in column

**obnoxs32** · 12-17-2007, 12:33 AM

I will attach two files along with this thread to better explain my question. I would like to take the data that is in Column A of Histogram Test file and somehow get excel to count the occurences each number is listed. I would like to have that information listed along the numbers in Column A of Histogram Test 2 file. Any help would be greatly appreciated. I will show an example of what I would like it to look like here:# of occurences can be in Column B if easier:
0-1
1-2
2-1
3-6
4-1
5-1
6-4
7-1
8-4
9-3
11-2
12-4
13-2
14-4
15-12
16-4

**Leith Ross** · 12-17-2007, 01:43 AM

Hello obnoxs32,

The following macro has been added to the attached file. This will sort the data (you have already done that), count the occurrences of each number, and place the count in the cell to the right.
Macro Code

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**obnoxs32** · 12-17-2007, 02:23 AM

I was amazed at the operation of the macro in one of my files. I was wondering if it is possible to have this macro put a zero next to the number in the column A that I use. So that it looks like this:
0-1
1-2
2-1
3-6
4-1
5-1
6-4
7-1
8-4
9-3
11-2
12-4
13-2
14-4
15-12
16-4
17-0
18-0
19-0

**obnoxs32** · 12-17-2007, 02:35 AM

If possible I would like to have excel go through column A to count the number of occurences like you did with the 1st Macro but using the list of 220 possible combinations attached below I would like to have a zero put next to the number if it did not occur. That way I could just copy and paste the Possibilities next to what Excel did and save the file. Hopefully it is possible.

**antoka05** · 12-17-2007, 05:11 AM

See macro in attached file... I hope it can help.

Regards,
Antonio

**obnoxs32** · 12-17-2007, 11:33 AM

The macro worked just as I wanted it to... I tried looking up the coding of it under tools>macro but nothing showed up. Then I checked to see if it was in the cells but nothing showed up. Does it have something to do with the Analyze Workbook button? Can I see the coding or statements within this file? Thanks for the help!!!!
Mike