+ Reply to Thread
Results 1 to 6 of 6

Spillable Function across multiple Dynamic Columns

  1. #1
    Registered User
    Join Date
    01-19-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    5

    Spillable Function across multiple Dynamic Columns

    How would I create a spillable function that computes across rows of mutliple spillable functions?

    For example:

    Let's say I have a simple sequence in Column A, I have three spillable arrays in B, C, D (this is not a matrix, but these are instead three unique spillable columns). Each spilling range has an equal number of rows always.

    Now let's say I want to create a product or a sum or some other function across each row. For example Sum (B5:D5) in Cell E5 and so on down each row in the column ... BUT, I want this to be spillable!

    Screenshot 2022-09-26 164126.png

    This seems like it should be easy to do - but I am having challenges and I have tried, offset, returning a row through INDEX. I can't figure out a way to make it spillable though.

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: Spillable Function across multiple Dynamic Columns

    Please try in E5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by HansDouwe; 09-26-2022 at 08:35 PM.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Spillable Function across multiple Dynamic Columns

    Another option
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-19-2019
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Spillable Function across multiple Dynamic Columns

    Oh you clever guy you! Thank you kindly. This thread is solved.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Spillable Function across multiple Dynamic Columns

    Not sure which of us you're talking to, but glad to help & thanks for the feedback.

  6. #6
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: Spillable Function across multiple Dynamic Columns

    Ditto ....

+ 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. Get UNIQUE list from multiple columns using Dynamic function.
    By yashbheda in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-05-2021, 10:32 AM
  2. [SOLVED] sum dynamic multiple columns across multiple sheets on userform
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2020, 09:11 AM
  3. [SOLVED] Average IFS with Multiple Criteria AND Multiple Dynamic Columns
    By MarkoGreenio in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2020, 12:49 PM
  4. Add data in multiple columns (dynamic # of columns)
    By neotaruntius in forum Excel General
    Replies: 7
    Last Post: 12-10-2019, 01:55 PM
  5. Replies: 8
    Last Post: 08-16-2019, 10:59 AM
  6. Replies: 2
    Last Post: 11-18-2015, 07:24 AM
  7. [SOLVED] Dynamic Unique List from multiple dynamic columns
    By JO505 in forum Excel General
    Replies: 7
    Last Post: 06-11-2015, 05:41 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