Thank you for your swift response. A few things, 1) It ended up creating new columns for result, CatA, CatB, 1st number and result, is there a way to avoid this and just have the result be the remaining column? 2) I forgot to mention this, but if there is nothing in the cells, then to treat the value in them as "1" ..... IE A B 3 3 A B - 3 A B 2 6 Thanks!
... View more