Identify missing numbers in a consecutive list using Excel
For this example, we have a list of a numbers in Column A and we’d like to check if there are any missing values assuming that they are supposed to be consecutive values, i.e., from 1-10 or from 234 - 456.
For this example, all of our values are listed from cells A1:A10 and we will [...]
