https://ask.libreoffice.org/en/question/11233/find-values-in-column-b-that-are-not-in-column-a/
=VLOOKUP(B1,$A$1:$A$100,1, )
If you have more than 100 rows of data, change the 100 in the formula to match the number of rows you have. Click in cell C1 then drag the handle down to the last row of data. This will copy the formula down. The function will look for the items in column B and see if they are in column A. If the item is found, column C will show the id, if not, it will show N/A. So the id’s in column B that have N/A next to them are not being used.
Also you can use formula =COUNTIF($A$1:$A$100;B1)=0 Or if the number of values ??in column A is less than 1024, you can use this method