Let put the count only the first time the number is found. Assume the
numbers start in A1. Put this formula in B1 and then copy down Column B
=IF(COUNTIF(A$1:A1,A1)=1,COUNTIF($A:$A,A1),"")
Countif will count the numbe of times a number appears.
**** First Countif ******
COUNTIF(A$1:A1,A1)=1 - Notice the dollar sign in front of the 1. This
will fix the first cell of the range when you copy down column B
B1 = COUNTIF(A$1:A1,A1)=1
B2 = COUNTIF(A$1:A2,A2)=1
B3 = COUNTIF(A$1:A3,A3)=1
B4 = COUNTIF(A$1:A4,A4)=1
B5 = COUNTIF(A$1:A5,A5)=1
**** Second Countif ******
B1 = COUNTIF($A:$A,A1)
B2 = COUNTIF($A:$A,A2)
B3 = COUNTIF($A:$A,A3)
B4 = COUNTIF($A:$A,A4)
B5 = COUNTIF($A:$A,A5)
The 2nd Countif counts the number of times the number appears in Column A
($A:$A) where the 1st Countif counts only the number of times the number
appears in the rows equal or above where the formula occurs.
The test for equal one will only be true the first time a number appears in
column A
the IF statement works like this
=if(Condition,true,false)
In the formula the false is not display anything which is "" the two sets
of double quotes.
So the formula