| Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: | | | | With Reassign collection numbers tool you can eliminate caps and duplicates, but I don't like to use it, 'cause I haven't found a way to audit what it actually did. Is there any tool or option how I could just see the duplicates and caps without program doing anything automatically? I could then fix 'em myself. |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,436 |
| | Posted: | | | | Do find duplicate or gaps you could export to CSV, open in Excel and use some functions in Excel to do that. To do that you could simply sort the collection number column and then have a simple IF function compare one cell with the one above it, giving some output if the cell value above is not one lower than the cell itself. | | | Achim [諾亞信； Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative) |
|