BrownEagle143
New Member
- Joined
- Nov 14, 2018
- Messages
- 2
Hi all, I am new to mrExcel. I have a typical requirement. Currently I have one document which as the inventory of the vehicles. I need to calculate the percentage of the number of vehicles by city in a new column. The sample data as follows
<tbody>
</tbody>
I need to calculate the percentage of vehicles in the next column by city in the following format
<tbody>
</tbody>
Thanks in Advance.
Country | State | City | Brand | no of cars |
USA | illinois | Chicago | Hyundai | 550 |
USA | illinois | Chicago | Honda | 1500 |
USA | illinois | Chicago | Toyota | 2500 |
USA | illinois | Chicago | Ford | 2200 |
USA | illinois | Chicago | Chevrolet | 1200 |
USA | illinois | Chicago | Kia | 450 |
USA | illinois | Aurora | Hyundai | 800 |
USA | illinois | Aurora | Honda | 1200 |
USA | illinois | Aurora | Toyota | 1242 |
USA | illinois | Aurora | Ford | 2750 |
USA | illinois | Rockford | Toyota | 758 |
USA | illinois | Rockford | Ford | 350 |
USA | Indiana | Indianapolis | Hyundai | 550 |
USA | Indiana | Indianapolis | Honda | 2458 |
USA | Indiana | Indianapolis | Toyota | 3685 |
USA | Indiana | Indianapolis | Ford | 1520 |
USA | Indiana | Indianapolis | Chevrolet | 2544 |
USA | Indiana | Indianapolis | Kia | 854 |
USA | Indiana | Indianapolis | Audi | 450 |
USA | Indiana | Indianapolis | BMW | 358 |
USA | Indiana | Fort Wayne | Hyundai | 230 |
USA | Indiana | Fort Wayne | Honda | 1245 |
USA | Indiana | Fort Wayne | Toyota | 3551 |
USA | Indiana | Fort Wayne | Ford | 784 |
USA | Indiana | South Bend | Hyundai | 1255 |
USA | Indiana | Fort Wayne | Honda | 358 |
USA | Indiana | Fort Wayne | Toyota | 712 |
<tbody>
</tbody>
I need to calculate the percentage of vehicles in the next column by city in the following format
Country | State | City | Brand | no of cars | percentage |
USA | illinois | Chicago | Hyundai | 550 | 6.55 |
USA | illinois | Chicago | Honda | 1500 | 17.86 |
USA | illinois | Chicago | Toyota | 2500 | 29.76 |
USA | illinois | Chicago | Ford | 2200 | 26.19 |
USA | illinois | Chicago | Chevrolet | 1200 | 14.29 |
USA | illinois | Chicago | Kia | 450 | 5.36 |
USA | illinois | Chicago Total | 8400 | ||
USA | illinois | Aurora | Hyundai | 800 | 13.35 |
USA | illinois | Aurora | Honda | 1200 | 20.03 |
USA | illinois | Aurora | Toyota | 1242 | 20.73 |
USA | illinois | Aurora | Ford | 2750 | 45.89 |
USA | illinois | Aurora Total | 5992 | ||
USA | illinois | Rockford | Toyota | 758 | 68.41 |
USA | illinois | Rockford | Ford | 350 | 31.59 |
USA | illinois | Rockford Total | 1108 | ||
USA | Indiana | Indianapolis | Hyundai | 550 | 4.43 |
USA | Indiana | Indianapolis | Honda | 2458 | 19.79 |
USA | Indiana | Indianapolis | Toyota | 3685 | 29.67 |
USA | Indiana | Indianapolis | Ford | 1520 | 12.24 |
USA | Indiana | Indianapolis | Chevrolet | 2544 | 20.48 |
USA | Indiana | Indianapolis | Kia | 854 | 6.88 |
USA | Indiana | Indianapolis | Audi | 450 | 3.62 |
USA | Indiana | Indianapolis | BMW | 358 | 2.88 |
USA | Indiana | Indianapolis Total | 12419 | ||
USA | Indiana | Fort Wayne | Hyundai | 230 | 3.96 |
USA | Indiana | Fort Wayne | Honda | 1245 | 21.43 |
USA | Indiana | Fort Wayne | Toyota | 3551 | 61.12 |
USA | Indiana | Fort Wayne | Ford | 784 | 13.49 |
USA | Indiana | Fort Wayne Total | 5810 | ||
USA | Indiana | South Bend | Hyundai | 1255 | 53.98 |
USA | Indiana | South Bend | Honda | 358 | 15.40 |
USA | Indiana | South Bend | Toyota | 712 | 30.62 |
USA | Indiana | South Bend Total | 2325 |
<tbody>
</tbody>
Thanks in Advance.