| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need the percentage of objects used in a drop-down box
I'm creating a spreadsheet of the different sites that I visit. There are 12
different areas that I have listed in a drop-down box. since there are multiple sites within a given area, they will show up on the sheet multiple times. What I need is to show the percentage of the 12 different areas I have visited as a running calculation. Example; NYC (2 times) Portland (3 times) Atlanta (1 time) Chicago (4 times). I made 10 visits, showing 4 areas 10 times and actually visited 33.33% of my areas -- John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CREATE SERIES OF PERCENTAGE OPTIONS 4 A VALUE. IN A DROP DOWN BOX | Excel Worksheet Functions | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| How to create a drop down menu for objects | Excel Worksheet Functions | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| VBA Objects | Excel Discussion (Misc queries) | |||
Threaded Mode
