@exceldictionary: 👉🏼 DM me 'SCRIBE105' and I'll send you this step-by-step guide to finding every missing value with one formula for FREE Comparing two lists manually to spot what or who's missing is slow, and it's easy to overlook a name or two. And you can actually do it with one formula. Combine FILTER, NOT and COUNTIF to check every name on your master list against a second list, and Excel returns only the names that are missing. Add or remove names from the second list and the missing list updates automatically. I used Scribe to capture every step as I built it, so it's ready to share as a step-by-step guide. It's perfect for billing checks, attendance lists, inventory audits, CRM cleanups and any time you need to compare two lists. Hey there, I’m Emma and I teach people how to use AI and Excel to automate their workflows and because I want you to be the most productive version of yourself at work. Follow @exceldictionary for daily Excel + AI tips.

1259

There are no more comments for this video.

To see more videos from user @exceldictionary, please go to the Tikwm homepage.