Im using LibreOffice Calc.
I have two separate column of number sets. I want to compare the two and come up with a 3rd column set of numbers from column A that don't have any of the sets of numbers in column B.
This is the answer i rec'd from one member of Experts Exchange.
In C1 type in formula: =IF(ISERROR(MATCH(A1;$B$1:$B$1000000;0))=1;A1;"") and copy formula down from C1 to wherever the last entry is in the B column so (C1-C31 for example).
The formula displays in column C the values that are in the list A and do not exists in list B.
But I cant seem to make it work. Is it possible for you you to show me via a video tutorial or walk me through it so i know what i am doing?