Function 07)


Add Function DOESANYCOLUMNMATCH to active workbook

Using the function

=DoesAnyColumnMatch(RowRange, ColumnRange, AcceptableRounding)

Finds whether or not any column of numbers fully matches another column of numbers. Generally useful when you have several, not just two, columns of numbers. It returns the column letter from the first column on which it matches.

 

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc