Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the below table where Weightage is nuber of bookings a person can
action in one hour. '17' is the total that has been actioned in 8 hours. I need to insert a formula where it shows what percentage of 8 hours has been has been utilised to action booking of each country so that the total percentage will be 100% Bookings Weightage Percentage 4 7.8125 2 5 0 13.75 0 13.75 9 20 2 5 0 18 0 37.5 0 7.8125 17 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP WITH WEIGHTAGE | Excel Discussion (Misc queries) | |||
how to limit the Weightage of any data & distribute excess to othe | Excel Worksheet Functions | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
percentage | Excel Worksheet Functions | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |