+ Reply to Thread
Results 1 to 8 of 8

how i can update my formula for calculate only filtered(seen) data

  1. 11-24-2014, 05:59 AM #1
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    how i can update my formula for calculate only filtered(seen) data

    hello my friends,

    inside the file u ll see results for Germany League
    my code calculating statistic for all results
    when i filter home team or away team, my statistics not changing
    how can i update my formula for calculating just shown data?
    Attached Files Attached Files
    Last edited by aaaaa34; 11-24-2014 at 06:06 AM.
    Reply With QuoteRegister To Reply
  2. 11-24-2014, 06:03 AM #2
    lokicl
    lokicl is offline
    Registered User
    Join Date
    09-27-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    86

    Re: how i can update my formula for calculate only filtered(seen) data

    Hi,

    Write a macro to copy the filtered data to another page.

    Based on the filtered values calculate your results.

    Regards,
    lokicl
    Reply With QuoteRegister To Reply
  3. 11-24-2014, 06:07 AM #3
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: how i can update my formula for calculate only filtered(seen) data

    the file attached in post #1 now
    Reply With QuoteRegister To Reply
  4. 11-24-2014, 06:27 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: how i can update my formula for calculate only filtered(seen) data

    J1=SUMPRODUCT((Tablo1[FT Home Goals]>Tablo1[FT Away Goals])*SUBTOTAL(103,OFFSET($C2,ROW(INDIRECT("1:"&ROWS(Tablo1[HOME TEAM])))-1,0)))
    L1=SUMPRODUCT((Tablo1[FT Home Goals]=Tablo1[FT Away Goals])*SUBTOTAL(103,OFFSET($C2,ROW(INDIRECT("1:"&ROWS(Tablo1[HOME TEAM])))-1,0)))
    N1=SUMPRODUCT((Tablo1[FT Home Goals]<Tablo1[FT Away Goals])*SUBTOTAL(103,OFFSET($C2,ROW(INDIRECT("1:"&ROWS(Tablo1[HOME TEAM])))-1,0)))
    Try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  5. 11-24-2014, 07:15 AM #5
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: how i can update my formula for calculate only filtered(seen) data

    nflsales,

    can u send ur code in the attached file please?
    my excel in turkish.
    i translated it but code gave error.
    Last edited by aaaaa34; 11-24-2014 at 07:26 AM.
    Reply With QuoteRegister To Reply
  6. 11-24-2014, 07:43 AM #6
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: how i can update my formula for calculate only filtered(seen) data

    see the attached file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-24-2014, 07:52 AM #7
    aaaaa34
    aaaaa34 is offline
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: how i can update my formula for calculate only filtered(seen) data

    thats it!!!
    bravo be bravo india!!!
    Reply With QuoteRegister To Reply
  8. 11-24-2014, 07:54 AM #8
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: how i can update my formula for calculate only filtered(seen) data

    Thanks for your feedback and reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. How to Automatically Update New Data within a Filtered Pivot Table?
    By templeoftyler in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-24-2013, 11:54 AM
  2. update master file with filtered data
    By coolin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2012, 10:09 AM
  3. Excel 2007 : Calculate Average on Filtered Data Only
    By Justinetme in forum Excel General
    Replies: 3
    Last Post: 09-16-2009, 06:01 PM
  4. [SOLVED] Can you create 1 chart that will update based on filtered data?
    By Diane in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-09-2006, 09:34 AM
  5. [SOLVED] automatic update of filtered linked data?
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 02-04-2005, 04:06 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