Hi Lori,

Thank you, that method helps.

Eric
Lori wrote:
This might help: to find differences in two or more columns, hold down
the ctrl button and select entire columns in turn then press:

Ctrl+\ (Edit Goto Special Column Differences).

The cells that are selected are those that differ from the comparison
column i.e. the one that contains the active cell. To remove column
headings from the selection press

Ctrl+Shift+\ (Edit Goto Special Row Differences)

once or as many times as is required. You can then format all the
selected cells in a different colour.


Eric wrote:
Hi Everyone,

I have a task that I have been doing by hand that is tedious and
inaccurate, and I am hoping a clever reader will be able to help me. I
have several columns of data in an Excel table that I would like to
quickly analyze and determine were the differences are. For example, I
might have 20 rows, and in column 1 I might have 19 'A' and 1 'V'; in
the next column I might have 6 'D', 8 'E', 5 'N', and 1 'Q', etc. What
I do by hand is highlight each change with a different color so that I
can track how and where they change.

Is there a macro that could do this? It is very tedious and time
consuming (not to mention in accurate) for me to do this by hand,
particularly when dealing with several hunderd columns and a 100 or so
rows.

Thank you in advance.

PS I have never written a macro, I just know that they are amazing!

Warm regards,

Eric