I am trying to filter a one larger range from a smaller range. The master range has duplicate entries, however, so when I try to filter from it, it pulls out all duplicates when I'd rather have it filter out only the number it should (preserving the remaining duplicate entries). For instance, if my master range is: Jon, Jim, Jim, Frank, and I want to filter Jim and Frank from that range, I'd like to have Jon and Jim (the second instance of Jim) remain.
Here is the formula I've been using (but it filters out all instances):
=IFERROR(FILTER(C2:M2, ISNA(MATCH(C2:M2, C3:H3,0))),"")
Here is the link to my spreadsheet.