Rebasing percentages in excel? How to

[ExcelNewbie150]

I have a list of countries expressed in percentages of a universe



Universe = 100% , individual countries as follows

Japan	6%
China	2.60%
Korea	1.20%
India	2%
HK	0.60%
SingaporE	0.30%
Taiwan	1.70%
Total	14%

How do I rebase those countries to 100% in Excel? so that say for example Japan becomes x % of those 14% total

 

[FormR]

Hi, welcome to the forum, is this what you mean?

Book2
	A	B	C
1	Japan	6.0%	41.7%
2	China	2.6%	18.1%
3	Korea	1.2%	8.3%
4	India	2.0%	13.9%
5	HK	0.6%	4.2%
6	SingaporE	0.3%	2.1%
7	Taiwan	1.7%	11.8%
8	Total	14.4%	100.0%
Sheet1

Cell Formulas
Range	Formula
C1:C7	C1	=B1*(1/$B$8)
B8:C8	B8	=SUM(B1:B7)

 

[RoryA]

Divide the country percentage by the 14% total.