Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort days of week
I have a list that I am trying to sort in a pivot table by the day of the
week. Column B is derived from column A but is formated dddd using the custom feature. I cant figure out how to get the list to sort just Saturday and Sunday entries. The pivot table will only list all of the day entries which would mean i would have to select every Saturday and Sunday entry from 300 rows . Not sure if I am explaining this clear enough but here is an example of what I see. Really would appreciate any help . Deb A B DISCHARGEDATE Day of the week 1/3/2007 Wednesday 1/2/2007 Tuesday 1/4/2007 Thursday 1/4/2007 Thursday 1/11/2007 Thursday 1/14/2007 Sunday 1/9/2007 Tuesday 1/14/2007 Sunday 1/28/2007 Sunday |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort days of week
Instead of inserting the following in B2:
=A2 and format as "dddd" use: =TEXT(A2,"dddd") -- Gary''s Student - gsnu200741 "ferde" wrote: I have a list that I am trying to sort in a pivot table by the day of the week. Column B is derived from column A but is formated dddd using the custom feature. I cant figure out how to get the list to sort just Saturday and Sunday entries. The pivot table will only list all of the day entries which would mean i would have to select every Saturday and Sunday entry from 300 rows . Not sure if I am explaining this clear enough but here is an example of what I see. Really would appreciate any help . Deb A B DISCHARGEDATE Day of the week 1/3/2007 Wednesday 1/2/2007 Tuesday 1/4/2007 Thursday 1/4/2007 Thursday 1/11/2007 Thursday 1/14/2007 Sunday 1/9/2007 Tuesday 1/14/2007 Sunday 1/28/2007 Sunday |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort days of week
Have a look at
datafilterautofilterfilter on col Bcustom =Saturday or =Sunday -- Don Guillett Microsoft MVP Excel SalesAid Software "ferde" wrote in message ... I have a list that I am trying to sort in a pivot table by the day of the week. Column B is derived from column A but is formated dddd using the custom feature. I cant figure out how to get the list to sort just Saturday and Sunday entries. The pivot table will only list all of the day entries which would mean i would have to select every Saturday and Sunday entry from 300 rows . Not sure if I am explaining this clear enough but here is an example of what I see. Really would appreciate any help . Deb A B DISCHARGEDATE Day of the week 1/3/2007 Wednesday 1/2/2007 Tuesday 1/4/2007 Thursday 1/4/2007 Thursday 1/11/2007 Thursday 1/14/2007 Sunday 1/9/2007 Tuesday 1/14/2007 Sunday 1/28/2007 Sunday |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort days of week
Thank you so much for your response.... you just saved me ...big time.
"Gary''s Student" wrote: Instead of inserting the following in B2: =A2 and format as "dddd" use: =TEXT(A2,"dddd") -- Gary''s Student - gsnu200741 "ferde" wrote: I have a list that I am trying to sort in a pivot table by the day of the week. Column B is derived from column A but is formated dddd using the custom feature. I cant figure out how to get the list to sort just Saturday and Sunday entries. The pivot table will only list all of the day entries which would mean i would have to select every Saturday and Sunday entry from 300 rows . Not sure if I am explaining this clear enough but here is an example of what I see. Really would appreciate any help . Deb A B DISCHARGEDATE Day of the week 1/3/2007 Wednesday 1/2/2007 Tuesday 1/4/2007 Thursday 1/4/2007 Thursday 1/11/2007 Thursday 1/14/2007 Sunday 1/9/2007 Tuesday 1/14/2007 Sunday 1/28/2007 Sunday |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
COUNTIF by days of week | Excel Worksheet Functions | |||
5 days week date (mon to fri) | Excel Worksheet Functions | |||
7 days of the week | Excel Discussion (Misc queries) | |||
Days of the week. | Excel Worksheet Functions |