Compare lists in Excel: 6 ways to find differences

TIP: Use the formula "=TEXTBEFORE(CELL("filename"),"[")" when defining a "Folderpath" name to import into Power Query. Note, that will have a trailing backslash which the hard coded path had in the file "Advanced filter in Excel filter by list.xlsx", but you can also get that with "=LET(Txt,TEXTBEFORE(CELL("filename"),"["), Ln, LEN(Txt), LEFT(Txt,Ln-1))".
As long as I'm here, I couldn't find the file for this video either.

Nice job. I really liked your use of multiple conditional formats to home in on the unique and duplicates. Thanks.

Saying clicking on this and that is not very explanatory, say the names of what did intend to do/click on .