Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
In Excel, how do I find all the range of numbers if I only have the start and end?
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!
1 Answer
- Anonymous6 years agoFavorite 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?