3
How can I count the amount of occurrence in Excel 2007? The desired outcome should be something like:
apple 1
berry 2
coconut 3
donut 2
grape 1
lime 1
I have tried =COUNTIF($A:$A,A7)
, but that didn't gave the desired result.
Sample Data:
apple
berry
berry
coconut
coconut
coconut
donut
donut
grape
lime
Does this give the desired outcome? – Jacob Jan Tuinstra – 2012-12-13T05:25:28.140
@pnuts: So actually no, but after removal of duplicates it will be. – Jacob Jan Tuinstra – 2012-12-13T11:33:35.293
1@pnuts: thanks for your effort. Sathya: 1 Up. – Jacob Jan Tuinstra – 2012-12-13T12:54:35.510
1@pnuts Thank you very much, I'm truly honoured and humbled by your comment :-) – Sathyajith Bhat – 2012-12-13T16:32:38.130
@Jacob as pnuts mentioned, this answer was meant to be a pointer, since OP didn't make it clear whether the dupe entries were required or not, I thought I'll leave a first glimpse answer to see this is what the OP wanted. I didn't expect you to post another comprehensive answer, and I truly didn't expect the OP to accept this right away. Thanks. – Sathyajith Bhat – 2012-12-13T16:35:10.633
The OP is right. I'm glad I was part of the process. – Jacob Jan Tuinstra – 2012-12-13T16:57:27.613