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