Results 1 to 4 of 4

Listing values in between min and max

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2012
    Location
    New Zealand, Auckland
    MS-Off Ver
    Excel 2008
    Posts
    2

    Listing values in between min and max

    I have a large spreadsheet with minimum and maximum values for different entries, I need to create a list of the values (whole integers) in between the minimum and the maximum.
    So for A, B and C I have a list of minimum values and maximum values (I have used semi-colon as cell-seperator).

    A-min; 4; 0; 2; 3; 0; 1; 9;
    A-max; 5; 1; 3; 5; 4; 3; 10;
    B-min; 2; 4; 6; 1; 0; 3; 3;
    B-max; 3; 5; 8; 3; 2; 5; 4;
    C-min; 2; 4; 0; 1; 1; 3; 0;
    C-max; 3; 6; 2; 2; 1; 4; 0;

    I need to get this returned:

    A; (4-5); (0-1); (2-3); (3-4-5); (0-1-2-3-4); (1-2-3); (9-10);
    B; (2-3); (4-5); (6-7-8); (1-2-3); (0-1-2); (3-4-5); (3-4);
    C; (2-3); (4-5-6); (0-1-2); (1-2); (1); (3-4); (0);

    As I need to do this across a very large spreadsheet (100 rows and 300 columns) I would prefer a formula approach. Also I am not skilled in VBA, but will give it a go if that is the way around it.

    Thanks in advance for your help
    Last edited by sknu; 01-22-2012 at 05:06 AM. Reason: error in my spelling

Thread Information

Users Browsing this Thread

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

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