+ Reply to Thread
Results 1 to 3 of 3

return FROM TO values from custom defined range , and return all possible combination

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    return FROM TO values from custom defined range , and return all possible combination

    hello friends ,
    i googled few things from below but dint find , what i am exactly looking ,
    please check sample file .
    1 ) column A,B,C has custom define sort/order values
    2 ) column E:J is where we can input values manually , FROM TO values ( for example FROM 5 TO 10)
    3 ) column L:N returns inbetween values mention in column E:J from columns abc respective ( for above example will return 5 6 7 8 9 10 vertically )
    4 ) column P:R will return all possible combination of values in column L:N ....

    point (1) and (2) is manually handled , point (3)and (4) is where marco has to work
    Attached Files Attached Files
    Last edited by raj soni; 05-28-2016 at 01:53 PM.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: return FROM TO values from custom defined range , and return all possible combination

    Maybe with this

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: return FROM TO values from custom defined range , and return all possible combination

    thanks alot LeoTaxi,
    everything seems possible with excel with your help .

+ 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. [SOLVED] Return the MAX value in a defined range of an array.
    By Brian Powell 66 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 02:56 PM
  2. [SOLVED] Return value if within range, return multiple values if ranges overlap
    By cde1983 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2013, 06:16 AM
  3. Return a value, based on a defined range.
    By elferous in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2013, 06:55 AM
  4. How to return cell values from another sheet where a defined value is set.
    By Twomoocows in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2013, 05:10 AM
  5. Replies: 2
    Last Post: 11-12-2012, 06:26 AM
  6. [SOLVED] Return a defined range of multiple cells
    By BFernandez in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2012, 08:21 AM
  7. Replies: 2
    Last Post: 03-15-2012, 07:23 AM
  8. [SOLVED] Return a value that falls within a defined range
    By Suzieq in forum Excel General
    Replies: 2
    Last Post: 07-25-2006, 02:45 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