excel

=FILTER(data!K2:K198,NOT(ISNUMBER(data!K2:K198)))    to find the non-numbers in the range specified

=SORT(UNIQUE(data!K2:K198))   to list all the numbers in that column range