Forum Discussion
Formula assist
Dears, i hope everything is well, is there any way to update the attached highlighted formula to be easier than the exist to give the target result as highlighted. Thanks in advance
If you have Microsoft 365 or Office 2021, you can clear H2:I41100, then enter a single formula in H2:
=IF(D2:D41100=E2:E41100, "", D2:E41100)
This will automatically spill to H2:I4100.
Thank you Mr. Hans for your response, kindly check the attached highlighted in red (it has a different formula need to combined to be in one consolidated formula)
It's the same idea: clear J2:J41100, then enter the following formula in J2:
=K2:K41100=H2:H41100
- Dear Mr hans, The formula in the first sheet have different formulas Column B IF(D22=E22,"",IF(B22>0,D22,0)) Column A IF(D266=E266,"",IF(A266>0,E266,0)) and i need to make them into one formula to get the target result
Are you sure that you attached the correct file? I don't see those formulas.