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!

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!

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!

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!