Hello so

two sheets with invoices numbers

they are dervied from two different systems and im trying to see which are the missing invoice numbers

both have been saved in a separate sheet

so sheet 1 is from a system elite

it has 12586 invoice numbers with duplicates (but i remove the duplicates)

sheet 2 is from IZA and it has

11115 invoice numbers


someone told me this formula

but it doesnt really show me the missing invoice numbers it shows me all the ones that are in both of the columns in the two different sheets


1=LET(list,VSTACK(P7:P20,Q7:Q20),UNIQUE(FILTER(list,list<>"")))