Get instant live Excel expert help to learn how to use Choose function in Excel

To update the graph, table & reporting period, once I choose different month from the dropdown list

Good Morning I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data

I have cascading dropdowns created in excel for a patient form. When choosing the type of patient, you will then have another drop down based on the first choice. The problem I am running into is once you choose the type of billing on the dropdown, I would like a cell to let the paramedic know which service will be doing the billing. So if "Bill to Workers Comp" is chosen then a cell should auto populate to state "First Pass Healtcare". If "Direct Bill" is chosen then "OHSI Corporate" should populate in the cell. The problem is the amount of variables in the dropdowns.

If it was possible to introduce higher driver pricing during specific hours to increase supply and decrease demand, what weekly schedule of price multipliers would you choose? Visualise in a heatmap. Could you please help me?

I download a text file from my credit card account of the previous months transactions. When I load the "external data" into my spread sheet I choose "fixed width." I can identify columns in the field that comes up but I can't move the display to the right to identify the remaining columns. My older version of Excel allowed me to scroll over. The new version doesn't.

New car. You have selected your dream car. Its retail price is $45,000 and down payment is 15% or $6,750. The dealer has four loan packages for you to choose from: Plan A, no price rebate, 2% per year rate; Plan B, $1,500 price rebate, 4% per year rate; Plan C, $3,000 price rebate, 6% per year rate; and Plan D, $4,500 price rebate, 8% per year rate. The loan amount is not changed by the price rebate. Loan duration is 4 years and repayments are to be made monthly. a. Construct a spreadsheet model for the loan packages, showing their monthly payment amounts.

How can I get the code to choose different items in a dependent dropdown list? Suppose I have a different list in each dropdown?

i need a dynamic formula that gives me result (Sum product) of 12 months column with values on around 15 rows (x times) 19 headers with various percentages on 15 rows. I need the formula to be dynamic, as i change the header, formula should identify which header column to choose to do a sum product with the months. Hope I didnt confuse you.

I need a formula that adds numbers (1-31) inside a calendar. Say the 13th is on a Monday, then I'll type "13" above my first Monday on my calendar that stretches 6 weeks, and it'll fill in the rest up to 31. However, there aren't always 31 days in a month. So it'll also need to have the flexibility that, should I choose to replace the "29" placed by the code, with a "1", it would then fill out 1-31 from that location

When I add in a filter to my dates column, the options to choose dates from within the filter menu do not appear in chronological order