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.

Using Publisher's merge feature to grab numbers from an Excel workbook, you can quickly number documents, such as event tickets or labels. Susan Harkins shows you how.

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.