+ Reply to Thread
Results 1 to 6 of 6

Formula for name match

  1. #1
    Registered User
    Join Date
    03-29-2020
    Location
    Sydney, Australia
    MS-Off Ver
    MAC MS OFFICE
    Posts
    3

    Post Formula for name match

    Hi everyone,

    I need help with a formula that can identify names on one sheet and create true value to the main as the master sheet.
    This is based on google classrooms with students submitting work. When they submit work, it shows the timestamp and names.

    I would like to create a master list of all the students throughout the whole grade and add a value complete or incomplete by matching up names from the submission sheet.

    Ideally, the master sheet will include weekly date task submission and have the column confirm their completion. The original google classroom sheet does not identify incomplete task.
    Attached Files Attached Files
    Last edited by My.nguyen129; 03-29-2020 at 08:40 PM.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Formula for name match

    Maybe

    =COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0

  3. #3
    Registered User
    Join Date
    03-29-2020
    Location
    Sydney, Australia
    MS-Off Ver
    MAC MS OFFICE
    Posts
    3

    Re: Formula for name match

    Thank you so much for the code. I created the code but it keeps saying true or false. Can I change the word true or false to complete or incomplete?

  4. #4
    Registered User
    Join Date
    03-29-2020
    Location
    Sydney, Australia
    MS-Off Ver
    MAC MS OFFICE
    Posts
    3

    Re: Formula for name match

    Quote Originally Posted by Phuocam View Post
    Maybe

    =COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0
    Can we have the word as complete or incomplete?

  5. #5
    Registered User
    Join Date
    03-15-2020
    Location
    Sydney, Australia
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    20

    Re: Formula for name match

    Use an If function, to display as Complete or Incomplete. IF(COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0=TRUE,"Complete","Incomplete")

  6. #6
    Registered User
    Join Date
    11-17-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Formula for name match

    =IF(Sheet2!B3=Sheet1!B2:C4, "yes","No")

+ 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: 15
    Last Post: 10-29-2019, 06:46 AM
  2. Fuzzy match formula to match partial email string in another list?
    By Akshay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-26-2018, 01:51 PM
  3. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  4. Replies: 11
    Last Post: 01-12-2016, 03:30 PM
  5. Replies: 1
    Last Post: 10-06-2014, 02:13 PM
  6. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

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