Results 1 to 9 of 9

Thread: A job for SP?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Hi Pascal,

    As you no doubt know, I'm not stellar at formulas, but I think this actually works.

    Where MyRange refers to:
    =Sheet1!$C$7:$C$9
    Formula:
    =SUMPRODUCT(--ISERROR(MATCH(A1:A5,MyRange,0)),B1:B5)
    I would add that in C7:C9, I entered the subjects' first and last names, as I guessed that the omitting of last names was unintentional? (At home currently, so I went by the picture, as I cannot see/open 2007+)

    Hope this helps?

    Mark
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •