| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" by using the key at the top. If the Number of the "Code" matches the "Number to Change" then change that number to the "Change to this Number" under the New Code colum. 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.worksheet.functions
|
|||
|
|||
|
Changing a Number in a Column Using Arrays
You've posted the same question to at least 3 Excel newsgroups. Please don't
cross-post. Joerg wrote in message ups.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" by using the key at the top. If the Number of the "Code" matches the "Number to Change" then change that number to the "Change to this Number" under the New Code colum. 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing a Number in a Column Using Arrays
see response in public.excel
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Joerg" wrote in message ... You've posted the same question to at least 3 Excel newsgroups. Please don't cross-post. Joerg wrote in message ups.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" by using the key at the top. If the Number of the "Code" matches the "Number to Change" then change that number to the "Change to this Number" under the New Code colum. 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing a Number in a Column Using Arrays
=ROUND(A1,-1)
" wrote: 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" by using the key at the top. If the Number of the "Code" matches the "Number to Change" then change that number to the "Change to this Number" under the New Code colum. 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 a Number in a Column Using Arrays? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Hybrid Mode
