Fairly easy to do. Excel can find the missing items. You can "pipe" the list of files into a text file and then open that in Excel with this command:
dir /b > list.txt
You'll need to be in your folder at a command prompt to run that command. Then open list.txt in Excel.
Follow these steps in Excel to find the missing numbers:
[FONT=Arial, Helv][SIZE=-1]It is assumed the list is sorted.
[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]
1. Highlight the second number all the way down to the last. So if your numbers are in cells A1 down to A100, please highlight cells A2 to A100.[/SIZE][/FONT][FONT=Arial, Helv][SIZE=-1]2. Click on Format - Conditional Formatting[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]3. Click on the "Cell Value Is" dropdown list, then click on "Formula Is"[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]4. In the box to the right, type +(A2-A1)>1[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]5. Click on the "Format" button, the "Patterns" tab, and the background color that you like.[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]6. Click on the "OK" button.[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]7. Click on the "Add »" button.[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]8. Click on the "Cell Value Is" dropdown list, then click on "Formula Is"[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]9. In the box to the right, type +(A2-A3)<-1[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]10. Click on the "Format" button, the "Patterns" tab, and the background color that you like.[/SIZE][/FONT]
[FONT=Arial, Helv][SIZE=-1]11. Click on the "OK" button. Click on the Conditional Formatting dialog box's "OK" button.[/SIZE][/FONT]
Numbers before and after a missing number will be in color now.
