Thursday 18 November 2010

Set Up Criteria Headings for Excel Advanced Filter

Title:
Set Up Criteria Headings for Excel Advanced Filter


Video:


Description:www.contextures.com Use an Excel Advanced Filter to copy data from an Excel table to a new location. Set up an advanced filter criteria range, with headings that exactly match one or more of the headings in the original table. Then, enter one or more criteria in the row below the criteria range headings. However, if you're using a formula in the criteria row, either clear the criteria range heading, or use a heading that is different than any heading in the original table. See the steps in this short Excel video tutorial.

Published:
19/Nov/2010

No comments:

Post a Comment