Count Frequency?

[melnikok]

I have attached a spreadsheet with what I want to do.

I need a formula that will tell me how many of a number are in a list. But I need it to record how many of each number are in the list, without knowing which numbers are going to be in the list. The list can hold any number from 0 to 1000. I don't want to do countif's from 0 to 1000. Is there a better way of doing this? I have to record the results for each number in its own cell so I can reference it later.

See attachated.

THANKS for any help on this,
Ken

[daddylonglegs]

Here's one way.

With your list of numbers in A1:A36 use this formula in C2

=IF(ROWS(C$1:C1)>COUNT(1/FREQUENCY(A$1:A$36,A$1:A$36)),"",MIN(IF(ISNA( MATCH(A$1:A$36,C$1:C1,0)),A$1:A$36)))

confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

and in D2

=IF(C2="","",COUNTIF(A$1:A$36,C2))

copy both formulas down as far as required

column C gives you a unique list of all numbers in the range and column D the count

[melnikok]

I finally got to work on this today and it works great. I really appreciate the suggestion for the formula. It is doing exactly what I needed.

Thanks again,
Ken