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.
apple berry berry coconut coconut coconut donut donut grape lime