Countif Function

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top