Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
substitution
dear gentleman,
There is a list of values f.e. 1 till 38, these values will repeat themselves..in the list. I would like to assign a number to each of these values, the thing is, the list of values is long and mixed. So I want for excel to do it for me. how can this be done? f.e. value 15 is assigned the number 10 and thus every time it is met on the list excel will assign the number 10 for to value 15. who can help me with this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
substitution
Off to the side of your data, or on a separate sheet of your workbook, create a table of the numbers that you want to assign to each value e.g. Cell AA11 = 10, Cell AB11 = 15 Cell AA12 = 11, Cell AB12 = 16 If your numbers from 1 to 38 are in Column A Then, as an example, your formula in Cell B2 would be =Vlookup(A2,$AA:$AB,2,FALSE) -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=548229 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substitution | Excel Discussion (Misc queries) | |||
why does ON = Ambiguous in substitution formula? | Excel Worksheet Functions |