Countif Function

  • Thread starter Thread starter Hardeep_kanwar
  • Start date Start date
H

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
 
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.
 
Back
Top