Results 1 to 8 of 8

Repeat a Dynamic Spill Range

Threaded View

Skip_General Repeat a Dynamic Spill Range 01-24-2022, 09:49 AM
Glenn Kennedy Re: Repeat a Dynamic Spill... 01-24-2022, 09:50 AM
AliGW Re: Repeat a Dynamic Spill... 01-24-2022, 10:18 AM
Skip_General Re: Repeat a Dynamic Spill... 01-24-2022, 10:33 AM
Fluff13 Re: Repeat a Dynamic Spill... 01-24-2022, 10:35 AM
AliGW Re: Repeat a Dynamic Spill... 01-24-2022, 10:36 AM
Glenn Kennedy Re: Repeat a Dynamic Spill... 01-24-2022, 11:04 AM
jdmardell1 Re: Repeat a Dynamic Spill... 01-24-2022, 10:26 PM
  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 or remove a tech from the list on the left, it would automatically adjust the spill range and repeat on the right.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Total all columns in spill range?
    By pdtc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2021, 03:52 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