Need a formula to count how many time each number came out.

[serge]

From A3:A300 I have random numbers from 1 to 45.
From C1:AU1 I have the numbers from 1 to 45.

Which formula should be use to count how many time each number came out in column A ?

Thank you.

 

[T. Valko]

From A3:A300 I have random numbers from 1 to 45.
From C1:AU1 I have the numbers from 1 to 45.

Which formula should be use to count how many time each number came out in column A ?

Thank you.

Try this...

Enter this formula in C2 and copy across to AU2:

=COUNTIF($A3:$A300,C1)

 

[serge]

Thank you Valko.

 

[T. Valko]

Thank you Valko.

You're welcome!