What is considered a duplicate ?
- all cells of one row matching all cells of another row ?
- matching cells in one particular column ?
- something else ?
Quote:
|
Is there a quicker way to find duplicates in a large excel file?
|
Perhaps the data can be loaded into an array to be dealt with.
Can you attach a small de-sensitized sample worksheet of what you're dealing with, maybe 100 rows or so ?
PS: Excel 2003 has max of 65,536 rows, you might want to change your profile to be what you actually have.