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
7 Replies
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
