maxjohnson
New Member
- Joined
- Jul 20, 2006
- Messages
- 45
I am trying to go through a long list making comparisons using a macro. say I have the following:
Col A Column B Column C
20 20 10
20 25 10
30 30 10
20 30 10
If the value in Col A = the Value in Col B, I want The value in Col C to be replaced by half the original value. In other words, the value in Col C for row 1 would be replaced by 5. There are thousands of rows. Can someone tell me a quick way to do this?
Thanks
Max
Col A Column B Column C
20 20 10
20 25 10
30 30 10
20 30 10
If the value in Col A = the Value in Col B, I want The value in Col C to be replaced by half the original value. In other words, the value in Col C for row 1 would be replaced by 5. There are thousands of rows. Can someone tell me a quick way to do this?
Thanks
Max