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:
<TBODY>
</TBODY>
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:
The Data list (Column A): ACTION SPORTS FTW </SPAN> |
ACTION SPORTS FTW </SPAN> |
ACTION SPORTS FTW </SPAN> |
ACTION SPORTS FTW </SPAN> |
ACTION SPORTS FTW </SPAN> |
ACTION SPORTS FTW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL ACC HW </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP GENERIC </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL APP LICENSED </SPAN> |
FOOTBALL FTW </SPAN> |
FOOTBALL FTW </SPAN> |
FOOTBALL FTW </SPAN> |
FOOTBALL FTW </SPAN> |
FOOTBALL FTW </SPAN> |
FOOTBALL FTW </SPAN> |
<TBODY>
</TBODY>