Hi,
Can you suggest me how to automatically fill one column based on condition.
Condition:
<colgroup><col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
I want to fill col C which is based on condition like shown above
if col A having same number with different status like 56 with 4 status in col B, I want col c will be filled with other status apart from "duplicate" like "open". Pls suggest how to fill col C with Formula
Can you suggest me how to automatically fill one column based on condition.
Condition:
Col A | Col B | Col C |
56 | open | Open |
56 | duplicate | Open |
56 | duplicate | Open |
56 | duplicate | Open |
78 | Closed | Closed |
78 | duplicate | Closed |
78 | duplicate | Closed |
78 | duplicate | Closed |
78 | duplicate | Closed |
I want to fill col C which is based on condition like shown above
if col A having same number with different status like 56 with 4 status in col B, I want col c will be filled with other status apart from "duplicate" like "open". Pls suggest how to fill col C with Formula