comparing two columns to find blanks

Storme Dunn

I was using countifs:field1,"isnotblank"@cell, field2,"isblank"@cell...that the jist of the formula. Am I on the right track? The columns are names and I need know when someone has entered a name in the "Last" field but not in the "First" field. Getting an "unparceable" error.

Paul Newcome

Try something like this...

=COUNTIFS([First Name]:[First Name], @cell <> "", [Last Name]:[Last Name], @cell = "") + COUNTIFS([First Name]:[First Name], @cell = "", [Last Name]:[Last Name], @cell <> "")

The first COUNTIFS grabs rows where the first name is filled in but the last name is blank. The second one grabs rows where the first name is blank but the last name is not. Adding these two results together should give you the count you are looking for.

Paul Newcome

Are you trying to just get a count or are you trying to flag each row?

Storme Dunn

Hi Paul,

I don't need to flag, just want a count.

Thanks,

Storme

Paul Newcome

Try something like this...

=COUNTIFS([First Name]:[First Name], @cell <> "", [Last Name]:[Last Name], @cell = "") + COUNTIFS([First Name]:[First Name], @cell = "", [Last Name]:[Last Name], @cell <> "")

The first COUNTIFS grabs rows where the first name is filled in but the last name is blank. The second one grabs rows where the first name is blank but the last name is not. Adding these two results together should give you the count you are looking for.

Storme Dunn

Ok, I will give it a try. Thanks

Paul Newcome

Happy to help. 👍️