formula help

[markster]

Hi - column a of my worksheet contains a list of transactions. I need to place a formula in column D that numbers identical transactions - i.e when transaction X001 appears the first time column D will say 1, if it appears again then column D will say 2 and if it appears again column D will say 3 and so on - any ideas?

Thanks

 

[Lewiy]

=COUNTIF($A$1:A1,A1)
Copy this down column D.

Hope that helps!

 

[Joe4]

Let's say that your data is in rows 2 to 100 and you are checking/counting the values in column A. Then in row 2, enter this formula:

=COUNTIF($A$2:A2,A2)
and copy down for all rows. This will give you your running counter.

 

[Gerald Higgins]

Assuming your transaction number is actually in Col A, try this

=countif(a$1:a1,a1)

and copy down as far as required