Terry Morin
Reputation: 33
Count values in a column that are not in a list - excel
I'm looking for a way to count values in a column that are NOT in a list.
Example would be employees filling out a form but spelled their name wrong. I'd like to count the instances where the names aren't in my list of employees. There's 65 employees in the list.
Upvotes: 2
Views: 410
Answers (1)
Harun24hr
Reputation: 36880
To count wrong spelled name use COUNTIFS() function.
=SUM(--((COUNTIFS(F2:F6,B2:B6)=0)))
If you want find list of wrong spelled names then could try-
=FILTER(B2:B6,COUNTIFS(F2:F6,B2:B6)=0)
Upvotes: 3
Related Questions
- Get the Count only values available in Specific list
- In Excel, How to Exclude a list of Values in COUNTIF
- How to count values that exist in other column within a range in Excel?
- Need to count certain values from a list in google sheets
- Excel COUNTIFS value not in a list
- Getting the number of values not in a list
- Count number of rows where value in a column is not a part of a list
- Count how many in range are not blank or in list
- Count rows that have cell don't existing in a list in Excel
- Count the number of values in a range that are not defined in a list