Group, on the excel table screening of all members in a group of birth is empty-CodePudding

Help you a great god, and I want to consult the excel whether can achieve the following effects, is screening all team members of the group date of birth is empty, how to implement?

Team name team members of birth
Zhang lili 2015-01-01
Li si huahua
Fifty and all the 2015-01-02
Zhang SAN pintar
Zhang SAN Vivian 2015-01-03
Li si ha ha
Fifty ha ha 2015-01-04

Display effect for:
Team name team members of birth
Li si huahua
Li si ha ha

CodePudding user response:

Can be achieved,
1. To choose the "birth" column, click on the Filter;

2. In the "birth" drop-down menu, choose "blanks";