CODEWITHSUNDEEP
excelcountif
Heinreich213
Heinreich213

Reputation: 131

Excel Countif with the first count only

I am using CountIf to find the number of duplicate values in a column. First I sorted the values in ascending order. Then I apply =COUNTIF(B:B;B2) and dragged it till end. The Results are as:

enter image description here

However, I don't want the values multiple times in the column C. Just need it for one time. Also is it possible without sorting the column B in ascending order?

enter image description here

Upvotes: 1

Views: 249

Answers (1)

user4039065
user4039065

Reputation:

Try this,

=if(countif(b$2:b2, b2)=1, countif(b:b, b2), text(,))

Fill down. The data does not require sorting.

Upvotes: 1

Related Questions