Formula to pick up blank cell names

  • Thread starter Thread starter admingirl
  • Start date Start date
A

admingirl

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.
 
You can use Autofilter for columns B and C (choosing "blank" option from
Autofilter dropdown list).

Regards,
Stefi

„admingirl†ezt írta:
 
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
 
Back
Top