sksanjeev786
Active Member
 Joined
 Aug 5, 2020
 Messages
 271
 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  =B2A2 
Thanks in Advance
Regards,
Sanjeev