Results 1 to 8 of 8

Generate result with spill formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    580

    Generate result with spill formula

    Hi, attached a file with the source data.

    Column B and the matrix in columns C to L are set up in a way that they can be referenced with the #-operator.

    The values in the output column N are the desired results.
    I want to get the same results but with a single formula only (rather than the formula provided that has to be dragged down), input in cell N2 that spills until row 11.

    Appreciate if someone can provide some ideas how to construct such an expanding formula with #.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. When using a formula I get the Spill error
    By viewotst in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-05-2021, 07:34 AM
  2. Keep Getting #SPILL! Error for my Formula
    By prestonfussell in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-28-2021, 05:49 PM
  3. [SOLVED] IFERROR Formula results in #SPILL
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-04-2021, 05:17 PM
  4. Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  5. Hashtag # to spill a formula - excel 365
    By Limor_OP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-13-2020, 02:22 PM
  6. [SOLVED] Filter Causing SPILL# in IF Formula
    By Fugdkn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-18-2020, 06:29 AM
  7. Replies: 1
    Last Post: 07-20-2005, 11:05 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