How to find files that do not exist, having lists?

Question

Google Sheets

There is a list of files that should have been generated. And there is a list of generated ones.
Need a new list of files that don't exist. I do it manually and I'm already quite tired of doing it manually

Answer 1

Try the FILTER formula on lists that are not in other lists
Data that is not in the given list

• A:A - should have been generated
  
• B:B - generated
  

=FILTER(A:A;ISNA(MATCH(A:A;B:B;0)))
See examples https://oshliaer.github.io/qna?target=post/google-...