Importing and Analysing xls Files

To create a filter, use the AutoFilter tool.

To summarize the data, create a Pivot Table based on the data in the download.

Attached is a sample file. Sheet 1 is the download data sample with the AutoFilter applied. Sheet 2 contains a Pivot Table that summarizes the data on Sheet 1.

Hope this helps,
theDude