+ Reply to Thread
Results 1 to 3 of 3

Appending more than two Columns using one Dynamic array or spilled formula.

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    Philippines
    MS-Off Ver
    365, 2021
    Posts
    26

    Appending more than two Columns using one Dynamic array or spilled formula.

    Appending more than two Columns using one Dynamic array or spilled formula. Hello, I'm trying to append two or more columns, but i used 3 seperate formulas. Please see attached file. Any help will appreciated
    Attached Files Attached Files
    Last edited by kenesuino; 02-02-2022 at 03:45 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Appending more than two Columns using one Dynamic array or spilled formula.

    Please try

    =IFNA(CHOOSE({1,2,3},A2:A6,D12:D16,C7:C12),"")
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-27-2020
    Location
    Philippines
    MS-Off Ver
    365, 2021
    Posts
    26

    Re: Appending more than two Columns using one Dynamic array or spilled formula.

    Thank you so muchh, it's so usefull! <3

+ 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] Turn a COUNT formula into a Spilled Array formula
    By sire152003 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-19-2021, 06:38 AM
  2. Listboxes and dynamic/spilled arrays
    By Mal Ba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2021, 09:06 PM
  3. Formula - Sum and multiplying - Dynamic array spilled behavior
    By ttch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2020, 02:54 PM
  4. Countifs / Sumifs with dynamic arrays (spilled ranges)
    By esbencito in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-08-2020, 02:43 PM
  5. Dynamic, Spilled, Named Ranges - how to override SPILL
    By TimB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-24-2020, 01:53 PM
  6. [SOLVED] YTD with dynamic spilled array
    By MatthewHart74 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-14-2019, 07:49 AM
  7. YTD with spilled dynamic array
    By MatthewHart74 in forum Office 365
    Replies: 0
    Last Post: 12-12-2019, 12:05 PM

Tags for this Thread

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