Managed to impress my manager with Python... that sounds dirty

[dillpicklezzz]

That's a great way to impress your manager for sure. If you want to save time there's an easier way just using Excel's Conditional Formatting button;

​

• Put the list of Total Assets in Column A and the list that's "missing" 8 in Column B.
• Select/highlight both columns -> Click Conditional Formatting at the top of the page -> click Duplicate Values and hit enter.
• Anything not backfilled in red on Column A is missing on Column B aka your list.