P
Pumpkin
Hey guys,
I need your wisdom as this is driving me mental:
I need to compile a list of results for supplier categories. There are only
4 Categories A,B,C,D.
Column D can have multiple results of a mixture of A,B,C,D.
What I need is to get a result in column E that is for the following
criteria if the cells in Column D have any of the (and could be a mixture)
following results:
A=A
AB=A
ABC=A
ABCD=A
BC=A
BD=B
CD=C
BCD=A
So for example if a supplier had 6 cells next to it containg C,D,B,D,C,D
this would then be an A Result as from the six cells there are a B & C entry.
Bit messy I know.
Any thoughts would help.
Pumpkin
I need your wisdom as this is driving me mental:
I need to compile a list of results for supplier categories. There are only
4 Categories A,B,C,D.
Column D can have multiple results of a mixture of A,B,C,D.
What I need is to get a result in column E that is for the following
criteria if the cells in Column D have any of the (and could be a mixture)
following results:
A=A
AB=A
ABC=A
ABCD=A
BC=A
BD=B
CD=C
BCD=A
So for example if a supplier had 6 cells next to it containg C,D,B,D,C,D
this would then be an A Result as from the six cells there are a B & C entry.
Bit messy I know.
Any thoughts would help.
Pumpkin