mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
Table
Col 1, 2, 3
=======
A, B, B
C, D, E
=======
I wish to:-
(1) If Col 2 = Col 3, then assign Col 4 = 1
(2) If Col 2 <> Col 3, then assign Col 4 = 1 in that record, then create same record plus Col4=-1 first, and then create another record
Col 3 = Col 2, assign Col4 =1
Col 1, 2, 3, 4
==========
A, B, B, 1
C, D, E, 1
C, D, E, -1
C, D, D, 1
The condition is VBA is forbidden. How can I do this ?
Pls help...
Col 1, 2, 3
=======
A, B, B
C, D, E
=======
I wish to:-
(1) If Col 2 = Col 3, then assign Col 4 = 1
(2) If Col 2 <> Col 3, then assign Col 4 = 1 in that record, then create same record plus Col4=-1 first, and then create another record
Col 3 = Col 2, assign Col4 =1
Col 1, 2, 3, 4
==========
A, B, B, 1
C, D, E, 1
C, D, E, -1
C, D, D, 1
The condition is VBA is forbidden. How can I do this ?
Pls help...