I'm dealing with 4 Columns with the following initial layout example:
<tbody>
</tbody>
I'd need, via either an equation or a macro, that the cells in Column V show the numbers I've highlighted in BLUE in each row.
Basically what's happening is that:
- If Column U = Empty, then Column T = Column S. This is fine because I do V = T, done.
- If Column U = NotEmpty, then Column T = Column S + (Column S - Column U). This is a problem, because what I'd need in Column V in these cases is only the part: Column S - Column U.
I hope that makes sense. Thanks in advance!!
COLUMN S | COLUMN T | COLUMN U | COLUMN V |
01, 03, 21 | 01, 03, 21 | ||
08, 15 | 08, 15, 08 | 15 | |
30, 33, 34 | 30, 33, 34, 30, 34 | 33 | |
09 | 09 |
<tbody>
</tbody>
I'd need, via either an equation or a macro, that the cells in Column V show the numbers I've highlighted in BLUE in each row.
Basically what's happening is that:
- If Column U = Empty, then Column T = Column S. This is fine because I do V = T, done.
- If Column U = NotEmpty, then Column T = Column S + (Column S - Column U). This is a problem, because what I'd need in Column V in these cases is only the part: Column S - Column U.
I hope that makes sense. Thanks in advance!!