How to merge Scenarios in EXCEL 2010

By -


How to merge Scenarios in EXCEL 2010

Prior to starting about our title, lets have a quick recap of "What Scenario is". Scenario can be defined as " Set of combination of values, that can be created for any fixed range of cells and may be used as and when required".

Excel also offers, Scenario Summary to get values of all combinations at once, so that we may look at all available combination at a glance.


Merge scenarios

  1. Select the worksheet in which to store the merged scenarios results.
  2. On the Data tab, in the Data Tools group, click What-If Analysis, and then click Scenario Manager.



  1. Click Merge.
  2. In the Merge Scenarios dialog box, click the arrow next to Book and select a workbook that contains scenarios that you want to merge in your results.
    3.  
  3. In the Sheet box, click the name of the worksheet that contains scenarios that you want to merge. 
  4. Click OK to merge the scenarios from the selected worksheet into the current worksheet.
  5. The Merge Scenarios dialog box closes, and the scenarios that you merged now appear in the Scenario Manager dialog box.
    6.  Repeat the step 3 to 6 as many times as needed until you have not merged all the scenarios that you want.
    That's all with the Concept of Merge Scenarios. Enjoy!!!!!!!

    Comments

    Post a Comment

    Popular posts from this blog

    Understanding Working of Text & Binary File in C

    By -
    Text file // assume that you have already created a   program file first.c and you want to display its contents on screen Ex 1: Program to show contents of any TEXT File on screen #include <stdio.h> main() {             FILE *fp;             char ch;             clrscr();             fp=fopen(“first.c”,”r”);             if (fp==NULL)             {                         printf("Cannot open file");                       ...
    Read more

    List of C Programs that makes u understand concepts in an easy fashion(Part1)

    By -
    A very Good Day to all my Readers, Today i received a Query Regarding solutions towards common C programs, using which one can understand the concepts of C in easy Way. So here is a complete Ready To Use Solution Kit for you reader Program 1 Program to print A to Z along with equivalent ASCII Value main() { int ch,c; clrscr(); c=1; ch=65; printf("Alphabet\t\t ASCII Value\n"); while(c<=26) { printf("%c",ch); printf("\t\t%d",ch); printf("\n"); ch=ch+1; c=c+1; } getch(); } Program 2 : Write C program to calculate Factorial of given Number main() { int fact,num; clrscr(); printf("Enter Any Number:"); scanf("%d",&num); fact=1; while(num>=1) { fact=fact*num; num=num-1; } printf("Factorial is %d",fact); getch(); } Program 3   Program to calculate Sum of first n natural numbers #include <stdio.h> main() { int n,t...
    Read more

    Starting C : A series of Chapters to learn C

    By -
    So far you have gone through the solved examples in my Blogs.I have received a lot of emails demanding “Step by Step learning of C Language'” in easy to understand language with illustrative examples. So here we go…. Chapter 1: Basic C Program Structure Prior to learning,the basic program structure, here are some rules to be followed while writing program, * C being case-sensitive ; entire program should be typed in Small Case letters(By entire program, we mean all the commands and keywords being used in the program). * Each new statement should begin with a new line. * To mark the finishing of each statement, place a semicolon(;) at the end of statement. The Basic C Program Structure #include <headerfile.h>                      (1) main()                       ...
    Read more