CODEWITHSUNDEEP
excelexcel-formula
AbhikM
AbhikM

Reputation: 75

Grouping cells with at least some value

I am trying to fill column N with a value say 'Yes' or 'No' based on the values from Column N to Column Z. It should return Yes if there's atleast one value from N to Z.

Alternatively, if I could just filter out the rows that don't have any values from column N-Z.

Is there a way to do this? Screenshot of the same excel sheet is attached for reference.

enter image description here

Upvotes: 0

Views: 38

Answers (2)

Error 1004
Error 1004

Reputation: 8220

Reference: CountA function count non empty cells.

Try:

=IF(COUNTA(N2:Z2)=0,"No","Yes")

Upvotes: 1

JvdV
JvdV

Reputation: 75870

Assuming you meant you trying to populate column M instead of N (according to your printscreen. You can simply use =COUNTBLANK function to count the empty cells in a range.

=IF(COUNTBLANK(N2:Z2)=13,"No","Yes")

Filter column M after you apply the formula to your range.

Upvotes: 2

Related Questions