| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a Number in a Column Using Arrays
I am trying to change a number in the left column to the number in the
adjacent column. My setup looks like this. Number to Change Change to this Number 182001 182000 182002 182000 193002 193000 Code New Code (from the Change to this Number column) 181000 181000 182000 182000 182001 182000 182002 182000 193000 193000 193001 193001 193002 193000 193002 193000 Essentially, this is an accounting problem. I need to change certain codes basically into a "rollup". I tried the array function but not sure if I am using it correctly. The "Code", "The Number to Change" and the "Change to this Number" are entered manually. Any suggestions? Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a Number in a Column Using Arrays
You've posted the same question (under different names ) to at least 3 Excel
newsgroups. Please don't cross-post. Joerg "cardan" wrote in message oups.com... I am trying to change a number in the left column to the number in the adjacent column. My setup looks like this. Number to Change Change to this Number 182001 182000 182002 182000 193002 193000 Code New Code (from the Change to this Number column) 181000 181000 182000 182000 182001 182000 182002 182000 193000 193000 193001 193001 193002 193000 193002 193000 Essentially, this is an accounting problem. I need to change certain codes basically into a "rollup". I tried the array function but not sure if I am using it correctly. The "Code", "The Number to Change" and the "Change to this Number" are entered manually. Any suggestions? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the number of columns within existing column(s) | Excel Discussion (Misc queries) | |||
| Can SUMPRODUCT work on changing arrays? | Excel Discussion (Misc queries) | |||
| Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
| Changing a Number in a Column Using Arrays? | Excel Discussion (Misc queries) | |||
| Use of offset and match functions with changing arrays, I think??? | Excel Worksheet Functions | |||
Linear Mode
