How to find columns which contain less than x null values


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

Advertisements

P

Pete_UK

You could put this formula in B10:

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

and then copy it across as required.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top