How to compare all columns in Excel?
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.
