Do you have a calculator similar to the Gaps and Missing Numbers treating each line as a new group? I have a lot of rows in excel with ranges I need to find the missing numbers in group of ranges. Simply copying in all the rows will display overlapping missing numbers in the ranges.
Group 1 Range :41050 - 41064 (only display the missing numbers between these these numbers)
Group 2 Range :42259 - 42273 (only display the missing numbers between these these numbers)
Created by this request
|Gaps and missing numbers finder|
This online calculator helps you find gaps and missing numbers in a sequence of numbers.