Look up dates
 

I have a spread sheet that contains dates, games played and a score

i.e

Date Oppostion Score
21/8/85 Canvey Island 3-0
30/8/85 Billericay 2-1
21/8/95 Eastbourne 0-1

Etc, etc

I want to be able to lookup all games that were played on a certain day
(excluding the year). So if i picked 21/8 i would get

Canvey 3-0
Eastborune 0-1

Thier might be 10 or more result for each day

Thanks

Alan

Alan

Autofilter should solve your problem nicely. Just Click Data / Filter /
Autofilter. Use the drop-down lists generated.

HTH
Steve

"Purfleet" wrote in message
...
I have a spread sheet that contains dates, games played and a score

i.e

Date Oppostion Score
21/8/85 Canvey Island 3-0
30/8/85 Billericay 2-1
21/8/95 Eastbourne 0-1

Etc, etc

I want to be able to lookup all games that were played on a certain day
(excluding the year). So if i picked 21/8 i would get

Canvey 3-0
Eastborune 0-1

Thier might be 10 or more result for each day

Thanks

Alan