How to compare all columns in Excel?

No replies
User offline. Last seen 2 years 49 weeks ago. Offline
Joined: 06/13/2009
Posts: 7

I have 10,000 columns in a sheet, and I need to check every single column against every other column to find if any of the columns match. I'm not trying to find duplicates from one column in another. I only need to know if the entire column in its current order matches another entire column in its current order. For example:

ABCD
1 3 1 1
2 2 2 2
3 1 5 3
4 4 3 4

Only ColA and ColD match exactly.

It can either be checked in Excel or VBA.