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