Closed Thread
Results 1 to 2 of 2

Repeat a Dynamic Spill Range

  1. #1
    Registered User
    Join Date
    12-14-2020
    Location
    Delaware
    MS-Off Ver
    Office 365
    Posts
    44

    Repeat a Dynamic Spill Range

    I'm trying to create a sheet that allows me to enter my list of techs in one column. To the right, I then want to create a repeating list (n times) of the the techs I have added. If I add, remove or change a tech in the list on the left, it would automatically adjust the spill range and repeat on the right.

    So currently my list of techs is A2:A11. I have created a filter in C2 that gives me the spill range of my techs (=FILTER(A2:A20, A2:A20<>"")). I want to be able to repeat that range in the column n times. If I add, remove or change techs, the filter would adjust the spill range and then repeat, etc.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Repeat a Dynamic Spill Range

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ill-range.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Repeat a Dynamic Spill Range
    By Skip_General in forum Excel General
    Replies: 7
    Last Post: 01-24-2022, 10:26 PM
  2. [SOLVED] Removing #spill! and then #N/A from the range
    By homa5424 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-01-2021, 07:01 AM
  3. #SPILL error using named ranges in dynamic formulae
    By goku1230 in forum Excel General
    Replies: 7
    Last Post: 06-06-2021, 09:05 AM
  4. [SOLVED] Rolling average cascading (spill) dynamic range formula
    By leolapa in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-10-2021, 08:32 AM
  5. [SOLVED] Dynamic Array Spill and Sort into 2 Columns
    By philchi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2021, 04:54 PM
  6. Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  7. 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

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