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
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
Have you tried using the same method as all the other formulas? I don't really understand what you're asking and why.