CODEWITHSUNDEEP
excelexcel-formula
Fahim Parkar
Fahim Parkar

Reputation: 31647

print occurrences in excel

Lets say I have data as 

2011
2012
2011
2012
2013
2013
2011
2012

Then what I want is 

2011     1
2012     1
2011     2
2012     2
2013     1
2013     2
2011     3
2012     3

Any idea to get this done?

Note that I want to get this done using Excel formulaes only. NO MACRO NO PIVOT NO CODING.

Upvotes: 0

Views: 51

Answers (1)

Jook
Jook

Reputation: 4682

I suggest you use the following formula:

B1=COUNTIF(A$1:A1,A1)

That's about it.

Paste down this formula and it will create the column with the counts.

Upvotes: 4

Related Questions