Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Changing a Number in a Column Using Arrays?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
carlsondaniel@gmail.com - 12 Sep 2006 04:54 GMT
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 to this Message
Joerg - 12 Sep 2006 05:12 GMT
You've posted the same question to at least 3 Excel newsgroups. Please don't
cross-post.

Joerg

> I am trying to change a number in the left column to the number in the
> adjacent column.  My setup looks like this.
[quoted text clipped - 19 lines]
> Change" and the "Change to this Number" are entered manually.
> Any suggestions?  Thank you!
Reply to this Message
Bob Phillips - 12 Sep 2006 08:22 GMT
=IF(ISNA(VLOOKUP(A2,change_to_table,2,false)),A2,VLOOKUP(A2,change_to_table,
2,false))

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I am trying to change a number in the left column to the number in the
> adjacent column.  My setup looks like this.
[quoted text clipped - 19 lines]
> Change" and the "Change to this Number" are entered manually.
> Any suggestions?  Thank you!
Reply to this Message
Pete_UK - 12 Sep 2006 10:28 GMT
If you essentially want to round down to a thousand, then this formula
will do that for you:

=ROUNDDOWN(A2,-3)

assuming your numbers are really numbers (not text codes) and that they
start in cell A2. Copy the formula down.

Hope this helps.

Pete

> I am trying to change a number in the left column to the number in the
> adjacent column.  My setup looks like this.
[quoted text clipped - 19 lines]
> Change" and the "Change to this Number" are entered manually.
> Any suggestions?  Thank you!
Reply to this Message

 Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.