Is there a way to search for a row that is "most opposite" to another row?
For instance, if the values in the "initial row" were 2 in column A, 2 in
column B, and -2 in column C, I'd want to find the "most opposite" row where
column A might read -2, column B might read -1, and column C might read 2 (as
opposed to a "similar" row where column A might read 2, column B 1, and
column C -1).

Thanks for any advice :)