Find missing number in a number sequence (ex: 2000, 2001, 2004, 2008) from excel column

I want to read excel data and find missing sequence numbers from that data table. examples in column A (2000, 2002, 2004, 2006, 2007) the best way to find and print missing values from this sequence of numbers.

@harsha_vardhan
we can implement as following:
Get the existing values as an ordered int array
grafik

create a complete sequence from lowest up to highest value
grafik

retrieve the missing values by comparing both series
grafik

Result:
grafik

Find starter help here:
Find_MissingItemFromSeries.xaml (7.6 KB)

2 Likes