Quote:
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.
|
Thanks for the reply, Arvi. Can you attach your version of the worksheet so I can see and reference to?