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
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.
I make a highlight for the different formula as a sample