For example:
I have 2125550010 and 2125550015. I need a way to give me everything that is missing from this range (0011, 0012, 0013, 0014).
Any help would be greatly appreciated!
Anonymous
Favorite Answer
Enter the first number in any cell, highlight the cell and right mouse click the lower right corner of the cell and drag it down as many cells as you need 10 or 50 does not matter, then select fill series and wit will end all the numbers that are next start from the initial number you inserted - ie adds 1 to the number and enters it into the next cell down and so on - does this help?