| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple numeric values applied to single text
Hello again guys & gals
I have several loan code for example 1,2,3,4,5,6,7,8,9,10,11,12 and so on. First five code translate as "consumer" (1,2,3,4,5) and 6,7 may be translate as "commercial", 8,9,10 may be "residential" and so on. I just have loan codes coming to me in one coulmn and they are in thousands. So far, I am going line by line and write the loan category according to it numric number.Is there any formula that I can apply and dgar it down to get the text value according to the loan code? Help will be appreciated Fam -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| Indentify value from multiple values in a single cell | Excel Worksheet Functions | |||
| two lines of text in single row | Excel Discussion (Misc queries) | |||
Threaded Mode
