Results 1 to 7 of 7

Scenarios - how can I list a number of results exceeding the limit of 32 cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2022
    Location
    Europe
    MS-Off Ver
    10
    Posts
    4

    Scenarios - how can I list a number of results exceeding the limit of 32 cells

    Hi,

    new here and need some assistance to find a way to overcome the 32 cells limit of the scenario function. Have searched the forum and internet for a while but did not manage to resolve the problem, yet.

    My task: I'd like to prepare a comparison for different setups and conditions. The idea is to compare the performance of four different engines (parameter A: 1 - 4) under ten test conditions (parameter B, 1-10) and calculate for all the 40 cases a set larger set of values for each of the engines. It was my idea to use parameter A and B to define / select the different SCENARIOS (define engine and test procedure for each scenario) which worked fine. Unfortunately I can't add all result cells I'd like to see to the Scenario Manager (most probably due to the limit of variable cells) and by this can't list the calculation results completely into the Scenario Report.

    Would be very kind if somebody has a hint how I could manage to list all results for each scenario.

    Thank you.
    Attached Files Attached Files
    Last edited by tony365; 03-23-2022 at 05:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to change other cells results with dynamic scenarios
    By Colin D in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2021, 02:55 PM
  2. IF function exceeding 8000+ character limit - need help on shorter formula!
    By paraclypse in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2020, 12:49 AM
  3. Replies: 4
    Last Post: 04-24-2009, 07:08 AM
  4. Getting error on exceeding some specific limit char
    By haroon_shah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2007, 07:58 AM
  5. [SOLVED] Sound For Calculated Number Exceeding Limit
    By Carl in forum Excel General
    Replies: 1
    Last Post: 06-22-2006, 07:15 AM
  6. Exceeding Cell Limit with HTTP requests
    By josephrowan in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 09:30 PM
  7. Exceeding the limit for Nested IFs
    By Beard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2006, 02:15 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