+ Reply to Thread
Results 1 to 4 of 4

Filtered View With Formulas - GOOGLE SHEETS

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Filtered View With Formulas - GOOGLE SHEETS

    Hi Guys,

    Is it possible to have your formulas in a filtered view? I have formulas in place but, when I got to my filtered view. It says "#REF The Formula in cell AA18 is referencing a range in an active filter that is not in the same row". Been trying to look it up but, looks like it's not possible.

    Is this true if not, can someone explain it or if their is a work around?

    Would be greatly appreciated.

    Warm regards,
    Vilac

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,885

    Re: Filtered View With Formulas - GOOGLE SHEETS

    Do you mean subtotal.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    11-18-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Filtered View With Formulas - GOOGLE SHEETS

    Hi AVK,

    I'm basically calculating the percentage difference. So:

    =(AA5-AA4)/AA4
    = (20675-21717)/21717 = 4.80%

    But when I use filtered view it says ""#REF The Formula in cell AA18 is referencing a range in an active filter that is not in the same row".

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,589

    Re: Filtered View With Formulas - GOOGLE SHEETS

    What is that formula?
    Can you share the file with us?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  2. Replies: 3
    Last Post: 11-09-2014, 11:09 AM
  3. unable view online google sheets."apologies there is no preview available"
    By choy96 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-09-2014, 02:24 AM
  4. How can't view and use filter data function in Google spreadsheet thought my Android phone
    By otterandrews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-08-2014, 10:37 AM
  5. Creating a link to view on google maps from cells
    By yenom2 in forum Excel General
    Replies: 3
    Last Post: 10-18-2012, 07:09 PM
  6. dropdown-->selected value-->filtered view
    By bijunator in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 11:38 AM
  7. Replies: 3
    Last Post: 08-16-2006, 10:10 AM

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