I had the following question answerd by Stefi earlier. Thanks again.

How do i get only one inidvidual number to be displayed in the first
relevant row rather than the same number in every row as below

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



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

Regards,
Stefi

€žMally€� ezt Ã*rta:

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