LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to determine the text?

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 abc
[2] 1 dcb
[3] 2 abc
[4] 3 tes
[5] 1 tes
[6] 2 tes
[7] 3 abc

I would like to select the text based on following order:
dcb (first), abc (second), tes (third)
For 1, it should return dcb in cell C1, because there is dcb in cell A2, and
this belongs to the first order, so the other order on abc (second) and tes
(third) will be ignored.
For 2, it should return abc in cell C2, because there is abc in cell A3, and
this belongs to the second order, the other order tes (third) will be ignored.
For 3, it should return abc in cell C3, because there is abc in cell A7, and
this belongs to the second order, the other order tes (third) will be ignored.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine the value - 23 Dec? Eric Excel Discussion (Misc queries) 2 December 23rd 08 09:48 AM
How to determine the value? Eric Excel Discussion (Misc queries) 3 November 13th 08 09:11 AM
Determine day of week in text format WLMPilot Excel Discussion (Misc queries) 6 October 6th 08 03:13 PM
How to determine the max. value? Eric Excel Worksheet Functions 4 July 2nd 08 02:46 AM
How to determine the value? Eric Excel Discussion (Misc queries) 1 February 13th 07 04:20 AM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"