UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Changing value of a cell based off another    
 
   
hibbii
post Feb 21 2007, 04:29 PM
Post #1

UtterAccess Addict
Posts: 148
From: VA, USA
In column A i have some accts that should have 0 Balances. How can I automate and go through and identify these accounts (0324, 0311,4024, etc.) and then change the "amount" column (column E) to the number 0. There are 5000 lines in this sheet.

TIA.
Go to the top of the page
 
+
statjunk
post Feb 21 2007, 04:55 PM
Post #2

UtterAccess Addict
Posts: 158
From: Michigan
I would write the following in the column next to your data.

If(or(acc=0324, acc=0311, acc=4024),0,Amount)

Then paste as values and delete the old column.

Tom
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 01:20 AM