This might be alittle work, but here goes:
In 'Library' create a column D, E, F next to your last name column (assuming last name is in Column C).
in E2 paste the last name you are looking up.
Enter the following in column D and paste down:
In F2 enter:
Now select column D and set a conditional format to highlight the cell when it = 1.
when F2 shows more than or equal to 2, then you know there may be a duplicate.
Then to make it easier to pull up the "duplicates", put a filter on column D and have it pull up values that equal 1.
Sorry for all the work, but one of the geniuses could probably do that in one single code or macro.
Bookmarks