Hello,
i often find your forum when i am looking for answers regarding Excel. Sadly, i havent found an answer to this one - yet, so i have decided to write to you.
I have a long list of categories in the column A (seen below). To this list i want to assign keys that will help me with further calculations (in a column B).
An example of such a key would be in the case of the given example "ACTION SPORTS" and "FOOTBALL". The whole list of these "keys" hast 17 elements.
It is evident that i will need some kind of a partial match. The one i have found on the internet, limittin itself just on the first or last number of characters wont work.
Would it be possible to select my "key - list" (all 17 of them). Then excel would asign a key, whenver it would find a partial match, matching the key?
Thank you very much for your help.
I have been looking for a solution for day and it's becomming quite urgent now :/
Kind regards,
Trgovec
-----------
Appendix:
[TABLE="width: 183"]
<TBODY>[TR]
[TD]The Data list (Column A):
ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
i often find your forum when i am looking for answers regarding Excel. Sadly, i havent found an answer to this one - yet, so i have decided to write to you.
I have a long list of categories in the column A (seen below). To this list i want to assign keys that will help me with further calculations (in a column B).
An example of such a key would be in the case of the given example "ACTION SPORTS" and "FOOTBALL". The whole list of these "keys" hast 17 elements.
It is evident that i will need some kind of a partial match. The one i have found on the internet, limittin itself just on the first or last number of characters wont work.
Would it be possible to select my "key - list" (all 17 of them). Then excel would asign a key, whenver it would find a partial match, matching the key?
Thank you very much for your help.
I have been looking for a solution for day and it's becomming quite urgent now :/
Kind regards,
Trgovec
-----------
Appendix:
[TABLE="width: 183"]
<TBODY>[TR]
[TD]The Data list (Column A):
ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]ACTION SPORTS FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL ACC HW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP GENERIC </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL APP LICENSED </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
[TR]
[TD]FOOTBALL FTW </SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]