Find and list the missing value in a column using a reference

I am trying to find the missing numbers in a sequence and have been using this formula, which works fine   =IFERROR(SMALL(IF(COUNTIF(K:K,ROW($K$2:$K$7))=0,ROW($K$2:$K$7),""),ROW(K1)), "")   When ...