Results 1 to 13 of 13

Excel Online How to get these functions to Spill

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Question Excel Online How to get these functions to Spill

    Hi There,

    I have excel file online in MS Office Online, as I am still on 2010, I am using online to take advantage of new functions in Excel.

    I am unable to get some functions to Spill if anyone could help me please.

    I have named ranges in another sheet for columns A to D populated cells starting from Row 2 till end of Data: "TimeStamp", "Price", "Volume" & "Value"

    In another sheet I have the following functions:
    =UNIQUE(TimeStamp) Spill is working fine in this column
    =MINIFS(Price;TimeStamp;A2#) Spill is working fine in this column
    =MAXIFS(Price;TimeStamp;A2#) Spill is working fine in this column
    =(B2#+C2#)/2 Spill is working fine in this column

    =STDEV.P(FILTER(Price;TimeStamp=A2)) I am Unable to get this to Spill Down
    =COUNT(UNIQUE(FILTER(Price;TimeStamp=A2))) I am Unable to get this to Spill Down

    =MINIFS(Volume;TimeStamp;A2#) Spill is working fine in this column
    =MAXIFS(Volume;TimeStamp;A2#) Spill is working fine in this column

    =COUNT(FILTER(Price;TimeStamp=A2)) I am Unable to get this to Spill Down
    Last edited by ibuhary; 09-04-2020 at 02:08 AM. Reason: Typo Error

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count IF returning spill
    By vini.v4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2020, 08:34 PM
  2. Good Online Courses for complex Excel functions
    By mdrungys in forum Excel General
    Replies: 4
    Last Post: 04-17-2020, 11:49 PM
  3. Replies: 13
    Last Post: 05-20-2017, 10:44 AM
  4. Replies: 2
    Last Post: 11-27-2015, 10:22 AM
  5. Re: Which are online microsoft excel online course ?
    By sun0flower in forum Excel General
    Replies: 0
    Last Post: 09-18-2012, 05:15 AM
  6. spill
    By april27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 12:55 PM
  7. Online reference available for x-fering functions into VB?
    By RAP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2005, 02:05 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