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