False 6 Advanced Filter False 0 0 dialog True False True True vertical 12 True False True end _OK True True True True True True Saves all changes and closes dialog. False True 0 _Cancel True True True True True Closes dialog and discards all changes. False True 1 _Help True True True True True False True 2 True False True end 1 True False True 0 none True False True True 12 12 6 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 0 True False Select the named range, or enter the cell range that contains the filter criteria that you want to use. 0 0 True True True True 30 True Select the named range, or enter the cell range that contains the filter criteria that you want to use. 1 0 True False Read _Filter Criteria From True lbfilterarea False True 0 True True True True True False 12 6 True True 6 True False True True 6 12 _Case sensitive True True False True True True Distinguishes between uppercase and lowercase letters when filtering the data. 0 0 Range c_ontains column labels True True False True True True Includes the column labels in the first row of a cell range. 0 1 Regular _expressions True True False True True True Allows you to use regular expressions in the filter definition. 1 0 _No duplications True True False True True True Excludes duplicate rows in the list of filtered data. 1 1 Co_py results to: True True False True True True Select the check box, and then select the cell range where you want to display the filter results. 0 2 _Keep filter criteria True True False True True True Select the Copy results to check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under Data - Define range as a database range. 1 2 0 0 True False 12 True 12 True False Copy results to: Select the check box, and then select the cell range where you want to display the filter results. 0 0 True True 1 True 30 True Copy results to: Select the check box, and then select the cell range where you want to display the filter results. 1 0 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 0 0 1 False False 12 False False Data range: 0 0 0 False False True dummy 0 1 0 0 2 True False Op_tions True Shows additional filter options. False True 2 ok cancel help Defines an advanced filter.