This function allows to remove columns from distance calculation based on the values in the columns.

• missing values: check this box if columns with missing values should be removed from distance calculation.

• text: enter a text that must be contained in the values of the columns. The search is done case-insensitve.

• column count: defines in how many cells the missing values or the text have to be found. Can be increased to search for columns with a specific count of missing values.