series help

[PrinceExcel]

Display the missing number in number series.

Ex :
Colum 1
1
2
3
6
7
8
Missing number is 4 & 5 that will display in Column 2 like;
4
5

 

[AhoyNC]

See attached link.
[h=1]Find Missing Numbers In A Series[/h]https://www.youtube.com/watch?v=_jel_Otcgds