Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Occurrences In A Column, Then Display In A Table
I need to figure out how to count occurrences (all lined up in two columns),
that will then be displayed in a table. The occurrences are a series of rankings (1 - 7) spaced over 20 intervals. The column looks like this. COLUMN 1 COLUMN 2 1 Sally 2 Sue 3 Sam 4 Suzy 5 Sherri 6 Sandra 7 Serena The above is repeated twenty times. The COLUMN 1 will have "1" in the very next row (say A9), with a different order for the seven girls. I created a table that looks like this NAME 1 2 3 4 5 6 7 SALLY SUE SAM SUZY SHERRI SANDRA SERENA I need a formula that will populate how many times each girl was selected first, second, third.... all the way to seventh. SALLY might look like this. NAME 1 2 3 4 5 6 7 SALLY 5 3 2 5 1 3 1 I tried creating a pivot table, but the pivot table is problematic since this order is randomly generated by using the F9 key. Whenever I 'refresh' the data in the pivot table, it re-randomize the numbers. The pivot table is then displaying the old numbers. This is for a report, so all the numbers must match. In short, I need this to run from a formula, and not a pivot table. THANKS!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of occurrences | Excel Discussion (Misc queries) | |||
Need column evaluated to count total of occurrences of "Y". How? | Excel Worksheet Functions | |||
Count Number of Occurrences in a Column | Excel Worksheet Functions | |||
Count occurrences of values in a column??!! | Excel Worksheet Functions | |||
Count unique occurrences of name | Excel Discussion (Misc queries) |