Mike H..
Active Member
Please see the attached workbook. The array formula in Col B is working exactly as expected.
The same formula in column C is wrapped in an IF statement so it only evaluates on certain rows but wrapping it in IF stops it working and I have no idea why. Any explanation? Am I making as silly mistake?
The same formula in column C is wrapped in an IF statement so it only evaluates on certain rows but wrapping it in IF stops it working and I have no idea why. Any explanation? Am I making as silly mistake?