When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing. When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing. When you are dealing with more than one list, a time comes when you have to confirm for whether you left a value missing.
So, to check your data and count the missing values you can use the countif function.
Previously in Excel Tutorials:- How to split the texts and numbers Using Flash Fill in Excel?
To understand it with a clear view, let’s take an example for the same:
Here we have taken two lists of food cause who doesn’t love food!
Now let’s input the formula:
The formula to count missing values is
=COUNTIF(
The following formula requires two things, one is the range and the other is the criteria.
Let’s say we want to check for whether the List B items are present in the List A or not, so basically our List A becomes the range.
After selecting the same, we come to criteria that is our list B.
Then we press enter. And drag the formula down so that we get a quick answer to all the values instead of jotting down the formula again and again for each value.
And as you can see your answer is right in front of you!
Through the above image, we can observe that the COUNTIF Function helped us to find out that “pie” as well as “plain fries” were the missing values in List A.
It’s easy, isn’t it?
