Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the text? | Excel Discussion (Misc queries) | |||
Determine day of week in text format | Excel Discussion (Misc queries) | |||
Random Text selection Q | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
losing text from text box when pasting selection to word | Excel Discussion (Misc queries) |