AUTO FILTER - AN OVERVIEW

Note: Once you use the Locate dialog box to look filtered info, only the information that's shown is searched; details that isn't displayed is just not searched. To search all the info, apparent all filters.The information involves four blank rows above the listing range that may be used as being a conditions array (A1:C4) and a listing range (A6: