Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Question | Excel Discussion (Misc queries) | |||
Array Question | Excel Programming | |||
Array question | Excel Programming | |||
vba array question | Excel Programming | |||
array question | Excel Programming |