aparicitudu
New Member
- Joined
- Aug 10, 2009
- Messages
- 8
Hi,
My requirements says to compare two i.e column A value with range of values and column B value with range of values and then populate column C with 1 or 0 based on the compare result.
<tbody>
</tbody>
For Example:
A B C D
NEW RAHUL 1(IF (A="NEW" & B="RAHUL") 1 (IF (A="PROGRESS" & B="RAHUL").....
PROGRESS RAVI ...... ........
COMPLETED RAHUL ....... ........
Please help me out in finding a solution for this.
Thanks,
Aparichit.
My requirements says to compare two i.e column A value with range of values and column B value with range of values and then populate column C with 1 or 0 based on the compare result.
A | B | C | D | E | F |
NEW | RAHUL | 1 | 0 | 0 | 0 |
PROGRESS | RAHUL | 0 | 1 | 0 | 0 |
COMPLETED | RAHUL | 0 | 0 | 1 | 0 |
NEW | RAVI | 0 | 0 | 0 | 1 |
<tbody>
</tbody>
For Example:
A B C D
NEW RAHUL 1(IF (A="NEW" & B="RAHUL") 1 (IF (A="PROGRESS" & B="RAHUL").....
PROGRESS RAVI ...... ........
COMPLETED RAHUL ....... ........
Please help me out in finding a solution for this.
Thanks,
Aparichit.