Array Question I think
 

I hope someone can point me in the right direction.

I have a list of names

Jeff
Don
Liz
Nicky
Bob
Jim

I then use the names of partners in a lab setting

Jeff and Don are partners in lab 1
Liz and Jim are partners in lab 1

I would like to determine who Jeff has not been a partner with. So my
results for Jeff would be

Yes
Don

No
Liz
Nicky
Bob
Jim

I was thinking of using a count function, but might be easier in a array??
Not too familiar with array's though.

Array Question I think
 

Seems like setting up a matrix in a worksheet like on a mileage chart would
be sufficient and then using a formula such as Find or countif against your
listing of partners (which you don't describe). the formula would look to
the row labels and column labels to identify the names to determine if a
partnership exists.

--
Regards,
Tom Ogilvy

"DanVDM" wrote in message
...
I hope someone can point me in the right direction.

I have a list of names

Jeff
Don
Liz
Nicky
Bob
Jim

I then use the names of partners in a lab setting

Jeff and Don are partners in lab 1
Liz and Jim are partners in lab 1

I would like to determine who Jeff has not been a partner with. So my
results for Jeff would be

Yes
Don

No
Liz
Nicky
Bob
Jim

I was thinking of using a count function, but might be easier in a array??
Not too familiar with array's though.

Array Question I think
 

Thanks


"Tom Ogilvy" wrote in message
...
Seems like setting up a matrix in a worksheet like on a mileage chart
would
be sufficient and then using a formula such as Find or countif against
your
listing of partners (which you don't describe). the formula would look to
the row labels and column labels to identify the names to determine if a
partnership exists.

--
Regards,
Tom Ogilvy

"DanVDM" wrote in message
...
I hope someone can point me in the right direction.

I have a list of names

Jeff
Don
Liz
Nicky
Bob
Jim

I then use the names of partners in a lab setting

Jeff and Don are partners in lab 1
Liz and Jim are partners in lab 1

I would like to determine who Jeff has not been a partner with. So my
results for Jeff would be

Yes
Don

No
Liz
Nicky
Bob
Jim

I was thinking of using a count function, but might be easier in a
array??
Not too familiar with array's though.