sort by day of the week?

A

Authentik

Excel 2002

I have 10 years of grain prices...one price for each trading day of th
year. In 'A' we have the date, in 'B' the price. What I need to do i
get a list of prices for Mondays, Tuesdays, Wednesdays, etc...

Possible? (I really, really don't want to do this manually)

Than
 
A

Authentik

Thank you. You saved me 3 or 4 hours of excruciating data entry. Thi
was the last step of a vital report. Now I can do my charting and g
home
 
D

duane

no problem....if the dates are really dates (and not text) you could
also format that column as custom.....ddddd and see the day names
 
Top