Say you have two columns
joe male
mary female
janet female
max male
connor male
jeff male
what formula do i need to get this result automatically wihtout using a filter?
Male
joe
max
connor
jeff