The solution lies with using Excel's array feature to traverse a data list automatically and extract missing sequential numbers, even if the number list is out of order.

A. In other words, you want to take a column of consecutive numbers or words, say, from 1 to 5 or Able, Baker, Charlie, and flip the order—running from 5 to 1 or alphabetizing the words in reverse ...

Learn how to multiply numbers in single cell, multiply multiple numbers from several cells, multiply column of numbers in Excel.