Formula to pick up blank cell names
 

I have a spreadsheet with names and dates of training next to them. I want to
pick up the names which are in the A column if either the B or C column have
been left blank (showing that they haven't been done) so it can be seen
easily who has not had the training.

Formula to pick up blank cell names
 

You can use Autofilter for columns B and C (choosing "blank" option from
Autofilter dropdown list).

Regards,
Stefi

€žadmingirl€� ezt Ã*rta:

I have a spreadsheet with names and dates of training next to them. I want to
pick up the names which are in the A column if either the B or C column have
been left blank (showing that they haven't been done) so it can be seen
easily who has not had the training.

Formula to pick up blank cell names
 

Hi,

You can also use Advanced Filters. Assuming your data is set up as follows
in range A1:C5, in cell A8 type, the following formula - =COUNTA(B2:C2)=0

Name Date of training Date of training (2)
A 01-03-2008F
03-03-2008
G
T 06-04-2008Now go the Filter Advanced Filter and in the list range refer to A1:C5. in
criteria range refer A7:A8 and in copy to, give the reference of any cell.

Hope this helps.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"admingirl" wrote in message
...
I have a spreadsheet with names and dates of training next to them. I want
to
pick up the names which are in the A column if either the B or C column
have
been left blank (showing that they haven't been done) so it can be seen
easily who has not had the training.