My Data looks like this:
Year Country
2000 Afghanistan
2000 Afghanistan
2000 India
2000 Malaysia
2001 Afghanistan
2001 Afghanistan
2001 India
2001 India
2001 India
What I need to do is to sort data like this:
Year Country Occurrence
2000 Afghanistan 2
2000 India 1
2000 Malaysia 1
2001 Afghanistan 2
2001 India 3
the occurrence is basically how many times a year has been repeated in the data-set. What is the best formula for this? Many thanks in Advance.
Bookmarks