Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Filter Definition Dialog Box. Lists the parameter specified for each filter criteria. Modify the settings for the filter using the controls in the Filter Definition dialog box.
Filtering Lists In Microsoft Excel Training Connection from www.trainingconnection.com
Filter Dialog Box F4 for Help for variable show blank screen or takes a lot of time to display the values. In the Create Filter or Modify Filter dialog box click the Definition tab. In addition to standard filters project provides AutoFilters visible at the top of each column in sheet views.
Modify the settings for the filter using the controls in the Filter Definition dialog box.
This will open the Advanced Filter dialog box. All the properties specified on a single line in the filter definition must be true to display a layer name a logical AND. In the Available Components box double-click Starts With or Contains. This will allow you to specify the location where you can get the list of unique records.
