+ Reply to Thread
Results 1 to 3 of 3

Merge two ranges into one

  1. #1
    Registered User
    Join Date
    04-02-2020
    Location
    stockholm, Sweden
    MS-Off Ver
    Office 365, 16.33. MacOS
    Posts
    10

    Merge two ranges into one

    Hi!
    Im about to make a list that is a summery of two ranges. My two formulas will create ranges that may vary in rows but be the same amount of columns (3). What Im looking for is a way to have a joined formula including both ranges, and when the first is finished, the next one extend the list.
    My first formula is complicated but is basically an extended =(A1:C10) (Both 1 and 10 will differ)
    My second is a filter formula =FILTER(F1:H20;D1:D20), creating a range with three columns and the same amount of row as values in D1:D20.
    Id like to think that a solution like =(A1:C10)(FILTER(F1:H20;D1:D20) would make a list with the outcomes of the two formulas, but it doesn't. Is there a way to merge these two lists using one formulas within one cell?

    Thank you very much in advance!

    Best wishes.

    Nils
    Attached Files Attached Files
    Last edited by nilsr; 10-17-2020 at 04:39 PM.

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Merge two ranges into one

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    04-02-2020
    Location
    stockholm, Sweden
    MS-Off Ver
    Office 365, 16.33. MacOS
    Posts
    10

    Re: Merge two ranges into one

    Hi Belinda,
    Now I've updated the post with a document. Thank you very much in advance!
    Best,
    Nils

+ 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. is it possible to merge consistent date ranges? sample attached
    By justinhampton81 in forum Excel General
    Replies: 2
    Last Post: 03-08-2012, 07:24 PM
  2. How to merge two ranges?
    By marlonsaveri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2011, 09:46 PM
  3. need to merge list of IP ranges
    By shawnm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2010, 04:36 AM
  4. merge 2 named ranges
    By roland willems in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2008, 08:53 AM
  5. [SOLVED] New to VBA: Compare workbook ranges, merge data and do additions
    By SueFrost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2006, 10:55 AM
  6. [SOLVED] merge ranges
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2006, 07:10 PM
  7. Merge ranges based on condition
    By BrianDP1977 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2005, 09:20 PM
  8. how to merge ranges from multiple worksheets
    By crowleydl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-05-2005, 02:24 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