Gaps and missing numbers in groups?
This content is licensed under Creative Commons Attribution/Share-Alike License 3.0 (Unported). That means you may freely redistribute or modify this content under the same license conditions and must attribute the original author by placing a hyperlink from your site to this work https://planetcalc.com/8591/. Also, please do not modify any references to the original work (if any) contained in this content.
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.
For example
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 an integer sequence. |
Comments