Hi!

I am using this Countif Function COUNTIF(A2:A156,A2)

It give me 3,2,1 and 2,1 and so on like A2,A3,A4 and so on

Now i want it look like this

1,2,3 and 1,2

There is another countif Function i am using COUNTIF(A:A,A2)
it give me 3,3,3 and 2,2,2,2 and so on

Can anybody tell me which Countif Function i use

Thanks In advance

Hardeep kanwar