What is the best way to compare 2 long lists of data and tell me what the differences are? Each is in its own column.
Tried lining them up and using the = formula but it has too much variance to sort and match up.

way shortened e.g.:
1
2
3
4
8
8
....

vs
1
2
3
5
9
...


THANKS!