View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine the text selection?

Does anyone have any suggestions on how to determine the text?

There is a list of data under column A and there is a list of text under
column B
For example
[1] 1 APPLE
[2] 1 BOY
[3] 2 APPLE
[4] 3 CAT
[5] 1 CAT
[6] 2 CAT
[7] 3 APPLE


There is a list of numbers under column A
1,1,2,3,1,2,3
There is a list of texts under column B, but the set order is based on
following order:
BOY (first priority on selection),
APPLE (second priority on selection),
CAT (third priority on selection)

I would like to select the text according to the numbers based on higher
priority for selection and return it under column C

If any 1 under column A contain more than 3 types of text as shown above,
then
I prefer to select BOY in cell C1.

[1] 1 APPLE
[2] 1 BOY selected
[5] 1 CAT

If any 2 under column A contains APPLE (second), CAT (third) under column B,
then I prefer to select APPLE in cell C1, because the APPLE has a higher
priority for
selection in cell C2.

[3] 2 APPLE selected
[6] 2 CAT

If any 3 under column A contains APPLE (second), CAT (third) under column B,
then I prefer
to select CAT in cell C1, because the APPLE has a higher priority for
selection in cell C3.

[4] 3 CAT
[7] 3 APPLE selected

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric