you'll want to add a column to your spreadsheet, label it "year", which picks
up the year from Enrollment Date column, i.e., =year()
then as mr. liengme suggests, auto-filter the data in your spreadsheet by
clicking on one cell within spreadsheet, click on Data on excel menu bar,
highlight Filter, highlight Auto Filter, and click.

each heading in spreadsheet will have arrow contained in it's cell. click
on arrow of newly created "year" column, highlight 2004, and have a great
weekend =D

"Tdahlman" wrote:

I have a spreadsheet with several columns.