Gaps and missing numbers in groups?

This page exists due to the efforts of the following people:

Henry

Timur

Timur

Karen Luckhurst

Created: 2020-02-13 21:08:11, Last updated: 2020-05-06 07:38:23
Creative Commons Attribution/Share-Alike License 3.0 (Unported)

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.

URL copied to clipboard
PLANETCALC, Gaps and missing numbers in groups?

Comments