Display individual number totals for rows

  • Thread starter Thread starter Mally
  • Start date Start date
M

Mally

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:
 
Start your table in row 2 and enter this formula in B2, then fill it down as
required!

=IF(A2=A1,"",COUNTIF(A:A,A2))

Stefi


„Mally†ezt írta:
 
Back
Top