Can any one help me determine the formula needed to accomplish this task?
I have two columns of numbers on the same worksheet. Column 1 is the beginning range of a 7 digit number and Column 2 is the ending 7 digit range. Some of the ranges are a 1 to 1 match (example: Beginning range is 1234567 and the ending range is 1234567). However, most of the ranges are much larger (example: Beginning range is 1234567 and Ending Range is 123767). I'm looking for a formula that will automatically expand this range and list all consecutive numbers between the beginning and ending range and if the number is the same in the beginning & ending range, then I need for that number to be listed in a column. I have 1622 rows with different ranges that I need to apply this formula to. My ultimate goal is to list all numbers in a single column to compare them to a master list of 6000 numbers to see what is missing. Any suggestions?