View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default Use of Parameters in Excel

Sarjak,

Highlight the column of data, including the header label. Then go to
Data | Filter... and click on AutoFilter. In the header cell, you'll
see an arrow. Click on it, choose Custom from the drop-down list, and
enter your parameters. The list will then only show those rows that
fit your parameters.