+ Reply to Thread
Results 1 to 2 of 2

Formula help: Checkoff a checkbox when certain criteria is met in preceding rows

  1. #1
    Registered User
    Join Date
    09-03-2024
    Location
    Portland, OR
    MS-Off Ver
    Office 16
    Posts
    1

    Question Formula help: Checkoff a checkbox when certain criteria is met in preceding rows

    I have an excel file with the NBA schedule for 2024-2025.
    See the photos below to help convey how the workbook is set up, what I am trying to accomplish, and the issue I am having.

    I have a helper column (Column T) that searches both Column J and Column M for the team name, to help me determine the date of that team's last game, regardless of Home or Away.
    helper column.png

    From that, I have a formula to calculate the number of days since the teams last game, regardless of home or away, into Column I or Column N.
    rest days formula.png

    And from that, I have a formula to check off the box in Column F or Column O (for B2B), depending on what is in Column I or Column N.
    B2B formula.png

    My goal is to have a formula that checks off the box in Column G or Column P, depending on if the team is playing 3 games in 4 days, regardless if they are playing Home or Away.

    The below image shows what SHOULD be checked off: The two highlighted teams (Yellow and Orange) should have a check in the checkbox, in the location indicated with the blue box, since they are playing their 3rd game in 4 days.
    what SHOULD happen.png

    I have tried ChatGPT4o to help me generate formulas, I have tried VBA, and nothing has worked for me....
    Can someone please recommend a formula to help me accomplish this task? I am not opposed to using a different method entirely if that is what is recommended.
    Here is a condensed version of the workbook.
    2024 - 2025 Schedule - WIP 2.xlsx
    Please help me!!!

    Thank you so much!

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,464

    Re: Formula help: Checkoff a checkbox when certain criteria is met in preceding rows

    Welcome to the forum.

    Please try in P2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

+ 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. Replies: 2
    Last Post: 12-27-2020, 04:10 AM
  2. Copy Rows to New Sheet Based Off Of Checkbox Criteria
    By Neuner in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-28-2018, 09:56 AM
  3. Multi-Line Cells to Rows, retaining info from preceding column.
    By DollarBankITAssetMgt in forum Excel General
    Replies: 6
    Last Post: 05-08-2018, 06:29 PM
  4. [SOLVED] Formula to return text from a preceding row
    By JYTS in forum Excel General
    Replies: 2
    Last Post: 09-15-2015, 01:45 AM
  5. [SOLVED] Formula to insert text in new column if preceding more than one of the preceding have val
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 11:47 PM
  6. [SOLVED] Formula to dynamically include one or more values from preceding row(s)
    By linksavage in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2012, 07:54 PM
  7. creating checkoff sheet
    By murfmo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2007, 04:35 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