How to do this advanced filtering in Excel?
The original data is in table 1, and five blank rows are inserted at the top of table 1. Enter gender in A 1, date of birth in B 1, male in A2, female in A3, and then = ">1976-12-3/kloc. B3 Enter = "> 1 975-1 2-31",move the mouse to Table 2: Data, Filtering, Advanced Filtering, select the original data area of Table1in the list area, and select A in the condition area.