what if data table

  1. J

    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. F

    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...
  3. B

    Please help! Sensitivity/What-if Analysis

    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...
  4. B

    Advanced What-If Analysis

    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. A

    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. I

    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. C

    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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top