frequencies of data

[YoCantu18]

Hi everyone,

I have a set of data that includes specific numbers. say 1,2,3 for example.

and I want to determine how many times the 1 appears, 2 appears, and so on.

Thanks for your help

 

[Weaver]

Take a look at the COUNTIF() function.

Alternativley (if you're feeling brave), you could try pivot tables.

HTH

 

[YoCantu18]

thanks alot. i think that will work. another quick question.

Is there a function that can list all the different specific values in a set of data?

 

[artvandelay]

You might also want to try the frequency function as a array formula.

{=FREQUENCY(Data,Counts)}

You need to have a column with the "bins" you want to find the frequency of (1,2,3 etc)

Also, with array formulas, you have to select all of the cells at once. ie: if you're going to put your frequency counts in cells A1:A10, you select the entire range, enter the formula in the bar at the top, and then press ctrl+shift+enter.