Extensive Data validation in excel
Posted by Mark Luckey on October 09, 2001 12:39 AM
Hello all,
nice to see you all online.
OK, here's the deal. Have several worksheets which contain data spread over about 15 columns, between 1200 and 65,000 lines long. I have to combine these worksheets, but wish to remove any entries which are identical across the 15 columns. Each existing worksheet is incomplete yet has duplicate data from others...if I combine them all, I get duplicates for many things. Affects the search on the final output. Data ranges (i.e. row 32567) is defined as different from the others if only one of the 15 columns (or cells) of data differs - an exact would be between 2 rows, if every value in the row was the same in corresponding columns.
Any idea how to fix this up? I need one final sheet which has all unique entries
Cheers
Mark