Countif Function

[Hardeep_kanwar]

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

 

[Joel]

You need to sort your data usinf column A and Key 1 and the column with
COUNTIF as the 2nd key. You 1st need to replace the formula for countif with
the actual value

1) copy the column with countif
2) Select PasteSpecial and choose Values and paste the column back into the
worksheet. the countif will disappear.
3) Sort the data range using column A as 1st key and the column that has the
countif values as the 2nd key.