Total numbers which are the same to be displayed

[Mally]

Hi
If i have a list of numbers sorted in column A i want to total the numbers
which are the same to be displayed in column B. Please see below

A B
1 2 3
2 2
3 2
4 1 2
5 1
6 4 3
7 4
8 4

Thank you in advance for any help.

 

[Stefi]

In B1:
=COUNTIF(A:A,A1)
and copy it to B4, B6, etc.

Regards,
Stefi

„Mally†ezt írta:

 

[Mally]

Thanks Stefi for your help

In B1:
=COUNTIF(A:A,A1)
and copy it to B4, B6, etc.

Regards,
Stefi

„Mally†ezt írta:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Mally†ezt írta: