Results 1 to 4 of 4

Is it possible to use TREND formula BYROW on a #Spill Range?

Threaded View

  1. 09-07-2023, 04:27 AM #1
    chris01395
    chris01395 is offline
    Registered User
    Join Date
    02-24-2019
    Location
    UK
    MS-Off Ver
    MS 365 PC & Mac (assume PC unless otherwise stated in post)
    Posts
    98

    Is it possible to use TREND formula BYROW on a #Spill Range?

    I am attempting to use formula like this;

    Formula: copy to clipboard 
    =BYROW(D3#,LAMBDA(a,TREND(a)))


    On a spill range but it does not work (#CALC error), and not sure why. Is it possible?

    Attachment shows example of data and desired output without referencing the spill range.

    Any help greatly appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] spill data over columns and rows with Byrow/lambda
    By Limor_OP in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-31-2023, 10:18 AM
  2. Formula to split text from each specific character to spill across range.
    By Mgc26133 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2022, 12:23 PM
  3. [SOLVED] Dynamically applying a formula to all of a SPILL range
    By diamond chap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2022, 02:23 PM
  4. [SOLVED] Spill range formula problem
    By zelezni in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2022, 05:09 PM
  5. [SOLVED] Date Range, Return Text, Formula VLookup #Spill! Error
    By CHillFL in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-27-2022, 05:05 PM
  6. [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
  7. how do I create a trend formula with range that changes
    By alison in forum Excel General
    Replies: 0
    Last Post: 01-25-2006, 06:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1