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.