Forum Discussion
Formula Help
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...
Todd_Winkle , that could be done with Power Query - query your columns with Start/End, generate lists for ranges and expand them to new column. That is in attached file.
After that you may merge that query with your master list to check what is missed and land final result into Excel sheet.
Thanks for the help SergeiBaklan. After figuring out that I had to download the Power query add-in, i was able to do what I needed to quickly. This was a great help!