How to find columns which contain less than x null values
 

Hi there,

I'm building a spreadsheet to help me track attendance.

I have each day of the month represented by a column, and names in rows.

I'd like each column to do a check to ensure I have no less than 6 null
fields.

ie:
1 2 3 4 5 .....
name1 x x
name2 x x
name3 x
name4 x
name5
name6
name7
name8

In day 1, there are 4 cells with null values, therefore that column should
be flagged somehow. Day 2 there are 6 nulls in that column, so no need for a
flag.

Any suggestions how I can accomplish this?

Thanks,

How to find columns which contain less than x null values
 

You could put this formula in B10:

=IF(COUNTIF(B2:B9,"")<6,"Flag","")

and then copy it across as required.

Hope this helps.

Pete


On Dec 29, 5:01*am, Geoff wrote:
Hi there,

I'm building a spreadsheet to help me track attendance.

I have each day of the month represented by a column, and names in rows.

I'd like each column to do a check to ensure I have no less than 6 null
fields.

ie:
* * * * * *1 *2 *3 *4 *5 .....
name1 x *x
name2 x *x
name3 x
name4 x
name5
name6
name7
name8

In day 1, there are 4 cells with null values, therefore that column should
be flagged somehow. *Day 2 there are 6 nulls in that column, so no need for a
flag.

Any suggestions how I can accomplish this?

Thanks,