| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a number value with text from array
I need to be able to replace customer ID numbers with the customer name on a massive scale. Is there any way i can say "13562 = Costco" for about 3000 different IDs. I have the master list of ids to names, but how would i go about doing a mass replace like this? Cant do a sort and cut/paste because some entries have the same customer id number. IE. 13562 13562 14200 15873 15873 15873 Thanks! JB -- JB1981 ------------------------------------------------------------------------ JB1981's Profile: http://www.excelforum.com/member.php...o&userid=34807 View this thread: http://www.excelforum.com/showthread...hreadid=549586 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Format Number to Text | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
