The lowest value in the range is the starting number in the sequence and the highest value is the last number in the sequence.
You can select a range of any size and the code will look for missing numbers (integers) in that range. Find to actually search for the numbers, it makes your life a whole lot easier. I’ve often seen complicated loops used to work through this type of problem, but when you can use. Get the workbook here Make sure it saves as a. Numbers in the sequence must be integers, i.e. Find method on an input range to look for the missing numbers in a sequence. We'll take -2 as the start of the sequence and 9 as the end. Let's say that your sequence looks like this :
This video explains how the code works, how to use it, and how to get the code and put it into your own workbooks.įor best viewing quality: Press play then You have a sequence of numbers, and you want to find the numbers that are missing from that sequence. Excel for Customer Service Professionals.
0 kommentar(er)
