COMPARE TWO LISTS WITH DUPLICATES TO EXTRACT EXCEPTIONS IN EXCEL

Hello,
Please i have two lists in excel and will like to compare to extract exceptions[ one list is typically more than the other] Here are two examples;

Example A [input] Example B [input]
LIST 1 LIST 2 LIST 1 LIST 2
A1 A1 A1 A1
A1 B5 A1 A1
B5 C6 B5 C6
C6 D4 C6 D4
D4 D4
D5

From the examples above, the desired output after comparing the lists in example one should be “A1”[ which is the only variable in List 1 that is not in List two since it appears twice in list 1.

From the 2nd example the desired output is “B5” and “D5”, which are the only variables in List 1 that are not in list 2.

Can i get some help with this in workfusion. All this will be done in excel.

Thank you

Could you share the sample captures and highlight the desired output?
I think the solution could be as [Open Spreadsheet] -> [Get Column] to list variable -> [Join Strings] to string variable -> [For Each] element in List2 -> [String Contains] to find out element exists