+ Reply to Thread
Results 1 to 4 of 4

If 2 Criteria are met, display true/false on different sheet

  1. #1
    Registered User
    Join Date
    03-31-2020
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    2

    If 2 Criteria are met, display true/false on different sheet

    Hi everyone, I'm new to the forum so bear with me please.
    I'm trying to create a sheet that will read submissions from Sheet1 and check them on Sheet2 against date and Student ID and display something like Submitted/Not submitted or True/False depending if criteria is met. I'm struggling to get it to check the date because the submission page includes time and check that it's the same row that the values are on. Each student will have an individual ID and the numbers could be into the hundreds so I would rather not do it manually. Any help welcome. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,504

    Re: If 2 Criteria are met, display true/false on different sheet

    does this work for you
    =IF(COUNTIFS(Sheet1!$A:$A,">="&Sheet2!$A3,Sheet1!$A:$A,"<"&Sheet2!$A3+1,Sheet1!$B:$B,Sheet2!B$1)>0,"Submitted","Not submitted")
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    03-31-2020
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    2

    Re: If 2 Criteria are met, display true/false on different sheet

    Hi Wayne, that's working perfectly. Thanks so much!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,504

    Re: If 2 Criteria are met, display true/false on different sheet

    you are welcome

+ 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. True/False to display with a duplicate entry
    By chris37422 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2015, 04:45 PM
  2. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  3. Display true false with IF formula
    By pcoutlaw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2012, 09:48 AM
  4. Compare two excel files and display true or false
    By sravanthi009 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-01-2011, 11:36 AM
  5. Excel 2007 : IF/AND TRUE/FALSE and two criteria
    By myparticulars in forum Excel General
    Replies: 11
    Last Post: 08-20-2009, 04:23 PM
  6. True/False indicator to display in different sheet
    By HPD in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-07-2007, 06:26 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