Quote:
Originally Posted by MKTGCLOUD
... but need to distinguish those keywords with a "doctor" and "professor" in it.
|
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.
11-27-2018, 02:31 AM
Similar Threads
lookup or filter data, update it and save it
Windows 8 
Office 2016
Threaded Mode