Question

Counting distinct values in excel - frequency function yes I have read Counting distinct values in excel - frequency function

I am trying to count a column with different numbers:

The column contains (search)

1 3 7 9 5 1 3 9 4

Expected result:

C1  C2
1 = 2
2 = 0
3 = 2
4 = 1 
etc

Answer 1

You can use COUNTIF to count the number of elements that match a condition.
Suppose you have your numbers in column A, say from A1 to A10:

A1: 1
A2: 3
A3: 7

etc...
Type in somewhere on your sheet, say in column B, the values you are interested in:

B1: 0
B2: 1

etc...
and in C1, type in
=COUNTIF($A$1:$A$10, B1)

This should count the number of values equal to B1 (i.e. 0), in A1:A10.