Create unique list of names from list of duplicates and that arefound within another range

[Jake]

Hello,

I have a list of 10 Contractors in worksheet1 Column A

In worksheet2 I have a bunch of rows of data of hours recorded by
Contractors and Employees for a particular project. The name of the
employee that recorded the hour is in Column B.

In that same worksheet, I would like to create a unique list of only
the contractors that contributed to that particular project (may be
only 1-3 of the 10).

Does anyone know of a formula that will allow me to do this? I found a
formula that will allow me to create a unique list, but does not
include the criteria that they be a contractor. Also, the formula I
found would force me to manually enter the number of rows of data that
I have (e.g., $B$2:$B$10) The formula I found is this:
=IF(ISNA(MATCH(0,COUNTIF($C$2:$C2,$B$2:$B$10),0)),"",INDEX($B$2:$B
$10,MATCH(0,COUNTIF($C$2:$C2,$B$2:$B$10),0)))

Any idea how I might do this with a formula?

If there is not a way to do this with a formula, does anyone have the
VBA code that would make this work? I have only a very little
experience with using VBA code in excel, but may be able to figure it
out.

Thank you so much for your help,

Jake

 

[Donald Guillett]

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."