Hi all, What excel equation would i use if i wanted to find out the percentage of a each country? So for instance i want to know what percentage of the below amount of country's was England? Also each day the amount of countrys will change as more are added so i want it to automatically update .
England
Scotland
Wales
Germany
Wales
Wales
England
England
Scotland
Wales
Spain
France
France
Germany
Egypt
Spain
Thanks
England
Scotland
Wales
Germany
Wales
Wales
England
England
Scotland
Wales
Spain
France
France
Germany
Egypt
Spain
Thanks