Advanced Filter with Formula
The request was to show all name of the doctor that match from 3 category of the filter. Category 1 : the name of insurance card that will be used. Category 2 : the age of the patient. Category 3 : the type specialty doctor required. Formula will be used is "FIND", "ISNUMBER" and "FILTER". 1. The idea was to get a "number" value if all category is match in doctor list, so will use "find". 2. As the match result should comes in number, all we need to check is whether its a number or not, so will use "isnumber" and will gives result of "True" or "False" 3. And the last, use filter to show up all doctor name that has "True" as a result. Sample in a simple way, let's assume the Age category has been divided to (Child, Teen, and Oldster) Sheet Filter And list of the sample doctor is as below; Sheet List Doctor and now, lets test the category from the sheet filter to each doctor, the formula should...