enxio27 wrote:
What I was wanting to do was to compare two puzzle collection files (imported into two sheets of a worksheet) to find duplicates between them, but I suppose I could just as easily put them (the smaller ones, anyway) into the same worksheet. I have several larger ones, though, that I won't be able to do that with (too many rows).
You obviously have FAR TOO many puzzles (> 500,000) What do you want with that many puzzles? It is more than you can solve
and push in one lifetime! I can now mass generate puzzles (>30 per second) solvable with either Naked Singles or Naked/Hidden Singles only. So using this program you could easily add a couple of million puzzles to your collection.
I do not think that inter-sheet removal of duplicates works, but trying is the best answer ... see comment to next quote. If inter-sheet removal of duplicates do not work, you could try Excel 2007, but 1,048,576 rows is probably also too little.
enxio27 wrote:
Hmmm. . . That sounds very good! I wasn't aware that leaving the copy option unchecked would hide the duplicates (the "Help" file isn't very clear on that).
Creative thinking and trying is often the best way, and faster than asking.
enxio27 wrote:
In other words, would a workbook (NOT spreadsheet) with several worksheets (worksheet = spreadsheet) of, say 50,000 lines each, with a couple of 81-character columns in each worksheet, be impossible (or excessively slow) to process for dupes and such?
I do not have that kind of puzzle collections, so I cannot try this. Please see comment to previous quote.
enxio27 wrote:
(I've already discovered that Excel 2003 can't handle subtraction of 81-digit numbers. . .
)
Of course excel can subtract 81-digit numbers, but not with a precision of 80 decimals, which you are probably looking for.
_________________
Quis custodiet ipsos custodes?
Normal: [D Y-m-d, G:i] PM->email: [D, d M Y H:i:s]