I have a large set of data (30,000+ entries) entered in one sheet across
multiple columns. It is assumed that each column contains a non-repetitive
set of data. I need a function that will cross check each column, and
indicate (either by generated list, highlighting, etc), common entries.
Entries are all text in nature, program is Mac Excel 2008. Any help is
appreciated.