Given a list of numbers, you can use FREQUENCY to find the number of occurrences in a given reference set (i.e. “=FREQUENCY(A1:A8,C1:C3)”. The problem is, that this damned answer is given to you in an array. I can’t graph the frequency, I can’t even see the numbers in the frequency.
Is there a command in Excel that will extrapolate the values of the damn array so I can see the frequency as referenced? 
I’ve tried ‘Help’ and. . . well, it just isn’t any.
Tripler
Getting seriously agitated about this. :mad:
I’m not entirely sure what you’re looking for, but have you tried playing around with variations on a COUNTIF statement?
=COUNTIF(range, criteria)
Sorry Tripler, but your question is too vague. Can you be more specific?
Did you try to put your frequency command in the an array of cells and press ctrl-shift-enter after editing it? If you did not put the formula in an array of cells you will not be able to see the array, only the first value.
What are you trying to do?
I’m not entirely clear what the question is, but I’ll give a simple example based on my interpretation of it, which I hope will get you where you need to go:
Let’s take simple one-column set of data, and place a column heading over it, e.g.:
Test Scores
92
80
92
76
84
70
Then do a Data > Sort to arrange the numbers from lowest to highest.
Next, do Data > Subtotals. In the dialog box that pops up, use the function “Count” to tally up each number. Excel will display the results in an outline. Click on the appropriate Level number (2, in this case) to collapse the outline. The display should look like:
70 Count 1
76 Count 1
…
92 Count 2
Grand Count 6
If you want to use this data as a group elsewhere, as in a graph, highlight the cells from “70 Count” through “92 Count…2”, then do Edit > Go To > Special and select the “Visible cells only” radio button. Now you can copy and paste this data to another worksheet and create your graph there.
This works for Excel XP. I don’t have an earlier version handy to see if the same commands will work for those or not.
If, instead of counting the occurrence of each cell entry, you want to count the occurrences in ranges, an alternative to FREQUENCY is to use Excel’s HISTOGRAM function, which also allows you to create graphs. You can get to it via Tools > Data Analysis > Histogram. Please note, however, that this feature (actually, the entire “Data Analysis” submenu) is only available if you’ve loaded the Analysis ToolPak add-in. It’s on the standard CD but is not automatically loaded as a part of the default install process.
My apologies for not being very clear in the OP. I was getting pretty frustrated, and the caffeine cut short at about 10:AM.
Earthling, your example is basically what I’m doing. I’m trying to sort test scores by tens, to get a statistical analysys. (It’s for a course.)
In any case, what I’m doing is trying to figure out how to use Excel for statistical analysys. I can do the mode, mean, median, yadda yadda, but my textbook says I can do “frequency analysis” as well. I tried the FREQUENCY function, and it gives me the correct breakdown of scores between say, 80 - 89, but the cell gives me the answer in an array format, i.e. {0,2,6,19,22,4,1}.
I want each of those numbers individually, in their own cell, so I can plot them in a graph. I want C1 = 0. C2 = 2, C3 = 6, and so forth. Do I have to set up an ‘array of cells’? How do I do that?Unless there’s a way to plot them directly from the array. . .
Yeah, I could just sort the raw data list and do it by hand, but I’m trying to learn to automate this process.
Tripler
I relinquish my title of ‘Supreme Allied Excel Commander’. 
Well I’ll be. . .
I get home, and it seems the FREQUENCY function works on my machine at home. I’ll have to try this at work one more time.
Although Earthling, I did install that Analysis Toolpak. That does make things easier. Much obliged!!
Tripler
I give you my title of ‘Supreme Allied Excel Commander’.