Originally Posted by ArviLaanemets

The formula returns either "doctor", "professor", or "doctor and professor". You set the autofilter for table on - you always can get a list of entries having "doctor" in them by setting the filter for formula column to "doctor" and "doctor and professor", or a list of entries having "professor" in them by setting the filter for formula column to "professor" and "doctor and professor", etc.