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,
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,