enxio27 wrote:
OK, thanks! Can it check for dupes through more than one sheet (presumably by highlighting multiple sheets)?
Just try it with a test workbook and you will find it out.
Even if this is possible I would strongly advice against doing so, unless you are capable of remembering how far you have processed X sheets. See next answer.
enxio27 wrote:
I don't see a way, though, to check just one column for duplicates but copy the entire row with the unique record to, say, a second sheet. I want to keep the data in the other columns (puzzle number, for instance) from becoming detached from the column with the puzzle data itself.
DO NOT check "Copy to another location" and leave "Copy to:" empty. Excel then hides all rows having duplicates. Now select the complete sheet (Ctrl+A) and copy (Ctr+C) and paste it to a new blank one. The hidden rows are not included, i.e. selected and copied
enxio27 wrote:
Is 65536 the maximum number of lines Excel can handle in a worksheet?
Yes, for all versions prior to Excel 2007. Excel 2007 can have 1,048,576 lines.
enxio27 wrote:
Is the FUNCTIONAL limit smaller?
I do not understand your question!
_________________
Quis custodiet ipsos custodes?
Normal: [D Y-m-d, G:i] PM->email: [D, d M Y H:i:s]