I am analysing 3000 sales invoice records in Excel. Quite a few have the wrong sales area code. Rather than overwrite the original data I have copied the "Area" column to another column "Area2" and made the corrections there.
What I want to do now is to print off a list of my changes but I can't work out how to do it. If the area codes were numeric I could subtract one from the other, but they are alphameric, eg change from "JS" to "DC".
There must be a simple way to do this. Can anyone point me in the right direction, please?