Is there a way to compare all rows to each other? I have a large 3000 row spreadsheet, and on one column, I would like to compare row 1 vs 2, 1 vs 3, 1 vs 4, 1 vs 5, 1 vs 6.....2999 vs 3000.
I know, that's 5 million combinations.
I will be dividing the smaller number into the larger number, to get a percentage/correlation.
Solved by O. Q. in 25 mins