sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data on Column F.
Thanks in Advance
Regards,
Sanjeev
I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data on Column F.
| FS1.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | WAVE 1 (A) | WAVE 2 (B) | Diff. | Difference Between (Wave 2 - Wave 1) (Need in this format) | ||||
| 2 | 53B | 14 | #VALUE! | 14 (-39) | ||||
| 3 | 22 | 24A | #VALUE! | 24 (+2) | ||||
| 4 | 21B | 15 | #VALUE! | 15 (-6) | ||||
| 5 | 10 | 11A | #VALUE! | 11(+1) | ||||
| 6 | 43 | 42 | -1 | |||||
| 7 | 7 | 6 | -1 | |||||
| 8 | 18 | 43A | #VALUE! | 43 (+25) | ||||
Sheet4 | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2:D8 | D2 | =B2-A2 |
Thanks in Advance
Regards,
Sanjeev
