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
create a complete sequence from lowest up to highest value
retrieve the missing values by comparing both series
Result:
Find starter help here:
Find_MissingItemFromSeries.xaml (7.6 KB)
2 Likes