what if data table

1. Data Tables (What-if-analysis) with Powerpivot

Hi, I have an Excel model that uses historical data as one of its inputs. The historical data is voluminous, hence instead of importing into excel and using VLOOKUP (or something similar), i opted to putting the huge database into MS Access, and then import into Powerpivot and using RELATED to...
2. How to match 3 variable cells

HI, I am trying to find a way for below problem, any help be highly appreciated. I have 2 cells for example C2 and D2, Which are dependent on A2, for example Changing A2 will change both C2 and D2. Question: if i want to achieve C2=80 and D2: 30, then A2 should be 5. given this scenario how...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...
5. newbie question "what if" function two variables (data table)

I am trying to learn how to use the "what if" function with two variables. Tried to find something in the Forum but in vain. To do this I have read Excel for dummies and here I ran into a Problem: How does What if" function work... I followed the books example and when that did not cut it I...
6. Rank Hypothetical value against list of actual values

Greetings Mr. Excel forum! I'm pretty good with excel and formulas, but I'm having some issues getting a simple rank formula to work on hypothetical data. I have a workbook that contains a list of several team members, ranked by their various levels of performance on one tab. On another tab...
7. DSum in What if Data Table

I have a list of products and units. I used the DSUM function to sum the specific product units. I place the product name in the criteria field of the DSUM function. I have 10 DSUM funtions with 10 different criteria areas and a different product name. Wanted to see if I could place the DSUM...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back