+ Reply to Thread
Results 1 to 3 of 3

Find percentage of last 10 weeks

  1. #1
    Forum Contributor
    Join Date
    10-15-2012
    Location
    Dallas, TX
    MS-Off Ver
    2019
    Posts
    167

    Find percentage of last 10 weeks

    I would like to find the winning percentage of the last 10 weeks with various criteria.

    In the attached workbook... The result would be placed in RESULTS F28-F34. As an example, I want to find the winning percentage of PMH over the last 10 weeks. In the prev column, I have the formula to calculate the winning percentage of all results per setup. All data is in the sheet DATA.
    Attached Files Attached Files
    Last edited by cableghost; 08-22-2021 at 03:13 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Find percentage of last 10 weeks

    Try

    =IFERROR(COUNTIFS(Table1[SETUP],B28,Table1[G/L],">=0",Table1[WEEK],">="&MAX(Table1[WEEK])-9)/COUNTIFS(Table1[SETUP],B28,Table1[WEEK],">="&MAX(Table1[WEEK])-9),"")

    I would amend your formulae to reference B28 etc rather than hard-coding the text such as "PMH"
    Attached Files Attached Files
    Last edited by JohnTopley; 08-22-2021 at 03:18 PM.

  3. #3
    Forum Contributor
    Join Date
    10-15-2012
    Location
    Dallas, TX
    MS-Off Ver
    2019
    Posts
    167

    Re: Find percentage of last 10 weeks

    Perfect, thanks JT! I also amended formulas per your input.

+ 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. find years with 53 weeks and red line
    By glda19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2017, 06:04 PM
  2. VBA Find Specific Weeks of Data
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-09-2016, 06:08 PM
  3. [SOLVED] Find Day of week in Data table and chart 4 weeks
    By Grimace in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 02:13 AM
  4. [SOLVED] Find weeks between multiple dates, and correspond with a cell.
    By bellyb in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-11-2013, 08:47 AM
  5. [SOLVED] To find Number of weeks passed
    By ashishmac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 01:40 AM
  6. How to find matches names & weeks between 2 pivot tables
    By kingcordova in forum Excel General
    Replies: 0
    Last Post: 07-12-2012, 08:12 PM
  7. How to find if new month started between weeks?
    By nmlnml in forum Excel General
    Replies: 1
    Last Post: 11-04-2009, 06:10 AM

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