You will need VBA to do this if you want the result to be in the "source" columns ( B & C) as a cell can only be either data or formula.