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/8589/. 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