How to compare two lists to find missing values in excel - Excel Tips and Tricks

Discover how to compare two lists to find missing values in Excel. You can use this same technique to compare two lists in Excel and pull not matching data. Likewise, compare two lists in Excel to find differences?

When working with data in Excel, it's common to have to compare two lists and identify the differences between them. In particular, you might need to identify who was present in the first list but is missing from the second one. This could be useful in a variety of situations, such as tracking attendance, monitoring inventory, or identifying discrepancies in financial records. By following a few simple steps, you can easily compare two lists in Excel and identify the missing data points. This will allow you to quickly and efficiently identify any discrepancies and take the appropriate action to rectify them.

Use this formula as shown in my video.

=FILTER(A2:A27,NOT(COUNTIF(B2:B19,A2:A27)))

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick

Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks

Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

How to compare two lists to find missing values in excel - Excel Tips and Tricks

Excel Tips and Tricks - Compare Two Lists In Excel And Highlight

Summarize Duplicates in Excel - Excel Tips and Tricks

Find difference quickly in Excel Comparing 2 List - Excel Tips and Tricks

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[harshit.k]

This is one of the most useful short video I've seen.

[denniswilson]

Just saved me hours of work. Thank you!

[Bashir_Kano]

Very easy and better than what I was using in terms of nesting formulas. Thanks

[bhaggoporiksha]

It will help my activity a lot. Thank u.

[RTTWOA]

It will save my time for my monthly task

[GoldenOrderGaming]

My excel shows FILTER as an invalid function. Do you know why?

[malekulashtarjawadwala]

How did you get formulae explanation when you are writing formulae ?

[bhuneshwarishetty]

After 1/5 an hour, I finally got some easy formula & easy to use😢

[thornmollenhoff]

This is good. I will definitely use this. How do you combine lists that have similar list items and each list also has unique list items into one list without duplicates?

[shume]

Just do conditional formating and select unique values

[gerardodelrio]

I dont like too much formula in my file, If I want to get the absentee, I'd just copy both columns into 1 single column and remove duplicates. but this is quite helpful as a template.

[rishabhchouksey]

Can you please share the sheet for practice

[bellatorresbruh]

I used it but it didn't highlight the correct names. A lot of the names that appeared on the absentee list were in both registered and attendee columns. Really weird.

[tharushikahettiarachchi]

=FILTER(<list1>, NOT(COUNTIF(<list2>, <list1>)))

[bga]

I hate excel for the variations in formulas. You use comma's. Why do I have to use semicolons?

[heimatcz]

It does not work at all. FIlter is no valid function.