+ Reply to Thread
Results 1 to 3 of 3

RETURN FVSCHEDULE as a SPILL ARRAY

  1. #1
    Registered User
    Join Date
    01-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010, 2013, 2016
    Posts
    47

    RETURN FVSCHEDULE as a SPILL ARRAY

    Hi all,

    This leads from an earlier request about returning spill arrays. I want to return the results of an FVSCHEDULE in a single spill array that I can then reference using the # reference. This is what I would like to see:

    Please Login or Register  to view this content.
    I hope this makes sense. Thanks for any help.
    Last edited by James McEwan; 11-20-2021 at 01:22 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: RETURN FVSCHEDULE as a SPILL ARRAY

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

    I don't know what you mean by "reference using the # reference"
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010, 2013, 2016
    Posts
    47

    Re: RETURN FVSCHEDULE as a SPILL ARRAY

    With some help elsewhere I was able to figure this out - the only change I had to make to the original data is convert the % change to a % of (so 103% instead of 3%):

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] TEXTJOIN in a Spill Array Formula
    By DJunqueira in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2021, 02:33 PM
  2. [SOLVED] Return MAX (or LARGE) for each 2D array's row with only ONE "spill" formula
    By leolapa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2021, 08:50 AM
  3. [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
  4. Spill array starting from zero
    By Sordini2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2021, 09:37 AM
  5. Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  6. [SOLVED] Getting SPILL reference when using IF to return from a range
    By TryingToLearnUK in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-22-2020, 07:53 AM
  7. [SOLVED] Using FVSCHEDULE with an array of data
    By JimDandy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-16-2017, 03:28 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