Check for blank values and assign blank value to all records for an ID

[snehithm]

Hi All,

I'm seeking out for help to generate a formula, that can check for the blank values for an attribute against an identifier. The identifier can have multiple records, but if atleast one of the record is blank, then default to blank for all the other records associated to the same identifier.

Please find attached a sample workbook with the expected output.

Thanks!
Snehith

 

[Joe4]

Welcome to the Board!

Place this formula in cell C2 and copy down to C13:

=IF(COUNTIFS(A$2:A$13,A2,B$2:B$13,"")>0,"blank","Not Blank")