+ Reply to Thread
Results 1 to 2 of 2

Using a What-If Analysis

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Using a What-If Analysis

    Hi guys,

    I have a spreadsheet I'm working on and my goal is to assess risk across rows. In essence the highest risk would use multiple contractors, but would have the lowest value. This was accomplished by listing the =min() of the column, and the sum of the minimums. I'm not sure if I need to run a macro, or an analysis to reduce the number of contractors (rows data compiled from). I want the end result to reduce my number of rows 1 at a time, typically increasing the value, but reducing the risk. I don't even know where to begin. Excel.jpg.

    Attached is an image the issue, hopefully that explains it more clearly.

  2. #2
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Re: Using a What-If Analysis

    As well the first reduction of row (or contractor) would be the difference of item list that equals the lowest value (so the overall greatest risk reduction for lowest value)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-06-2014, 11:00 AM
  2. Replies: 2
    Last Post: 06-28-2013, 08:43 AM
  3. Data Analysis- advanced pivot functions for employee analysis
    By Dsankie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-10-2013, 12:30 AM
  4. Why " data analysis plus " override " data analysis " once instal.
    By Alfred H K Yip in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2005, 05:06 AM
  5. Analysis ToolPak installed but no Data Analysis option
    By Eric Stephens in forum Excel General
    Replies: 3
    Last Post: 02-02-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1