Excel Missing Numbers in a Sequence
In this video you will learn about Excel missing numbers in a sequence, including:
Functions that you can use alongside each other to work out if there are any numbers missing in a sequence
What the two functions are and how to use them both
An example spreadsheet showing both being used
** NOTE: this 'fix' mentioned in the blog post and video only works on pure numbers **
Spreadsheets contain lots of numbers and if there was one or two missing it wouldn't be unreasonable if you missed them. In this video we look at two functions that you can use alongside each other to 'fix' the issue of missing numbers in a sequence.
Some related videos you might like:
UNIQUE Function in Excel - • UNIQUE Function in Excel
Dynamic Arrays in Excel - • Dynamic Arrays in Excel
We also have a number of playlists on our channel that you might like to look at. One of these being Advanced Functions/Formulas in Excel - • Advanced Functions/Formulas in Excel
Our Excel missing numbers in a sequence video is also included in our hint and tip post that can be found on our website - https://www.jplcomputer.co.uk/2024/05...
If you would like more information about us, pop over to our website here - https://www.jplcomputer.co.uk/
#MsOffice #MsExcel