Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method
У вашего броузера проблема в совместимости с HTML5
Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT539-550.xls
See how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of records and extract only the new records (records that are in new list but not in old list).
Compare Two 2 Lists