How to find columns which contain less than x null values

  • Thread starter Thread starter Geoff
  • Start date Start date
G

Geoff

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,
 
You could put this formula in B10:

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

and then copy it across as required.

Hope this helps.

Pete
 
Back
Top