Results 1 to 9 of 9

Dynamic, Spilled, Named Ranges - how to override SPILL

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2008
    Location
    Boston Massachusetts
    MS-Off Ver
    Excel for Office 365
    Posts
    28

    Dynamic, Spilled, Named Ranges - how to override SPILL

    I have a spreadsheet I put together a couple years ago that used to work great, and now is screwed up by the new dynamic, spilled array .... stuff.

    The spreadsheet uses cell values in a named range, say column B, as input parameters in a variety of formulas located in cells of column C.

    In the template file the first character in the formula cells is an &, so that this column can be used to populate tables for different projects, then can be replaced with = to convert them to functioning formulas.

    I used this file for the first time in a while and now the use of the named range is, apparently, triggering this lovely new dynamic array SPILLED function thing.
    It wants to use the formula in cell C5 to spill down results using the values in cells B5 thru B55.

    None of the formulas contain dymanic spilled operator commands.

    Can we not use named ranges as regular old array functions anymore?

    How do I fix this?

    Updated, any formula I write in the tab with the name of the named range acts as a spilled formula. LOVE IT!
    Last edited by AliGW; 02-22-2020 at 05:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] YTD with dynamic spilled array
    By MatthewHart74 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-14-2019, 07:49 AM
  2. YTD with spilled dynamic array
    By MatthewHart74 in forum Office 365
    Replies: 0
    Last Post: 12-12-2019, 12:05 PM
  3. [SOLVED] Dynamic Named Ranges
    By sandy1977 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-07-2018, 11:13 AM
  4. Dynamic Named Ranges?
    By Dinosaurmapman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2015, 01:10 AM
  5. Dynamic named ranges
    By Hilton1982 in forum Excel General
    Replies: 1
    Last Post: 01-08-2013, 08:37 AM
  6. Named ranges-Should I use a dynamic named range
    By foseco in forum Excel General
    Replies: 4
    Last Post: 06-11-2009, 03:56 PM
  7. Dynamic named ranges
    By SFoley in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-10-2006, 11:30 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