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

"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."


On Feb 17, 12:55*pm, Jake <jakebetz...@gmail.com> wrote:
> 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