Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

Dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rbrickl - 29 Jun 2006 19:12 GMT
I have recently made a list with drop downs for order analysis.

I have the date price department and account for drop down titles.

I already have all the data.  The dates are numerical
example(6/28/2006).  When I go to my drop down menu to organize all the
purchases for a certain month all that comes up is all the dates.  When
I bring the drop menu down I want the selections to be the name of the
month example(june).

Thanks

Signature

rbrickl

Gord Dibben - 29 Jun 2006 19:58 GMT
Format the dates in the list range as custom  mmmm

OR is there more to this than I read?

Gord Dibben  MS Excel MVP

>I have recently made a list with drop downs for order analysis.
>
[quoted text clipped - 7 lines]
>
>Thanks
rbrickl - 29 Jun 2006 20:28 GMT
Yah there is a little more to it.  See Attachment for details about how
the dates show up in the drop down menu.

+-------------------------------------------------------------------+
|Filename: Date.doc                                                 |
|Download: http://www.excelforum.com/attachment.php?postid=4958     |
+-------------------------------------------------------------------+

Signature

rbrickl

Gord Dibben - 29 Jun 2006 21:54 GMT
I'm not about to start chasing around to other sites when you could add to your
description and post here.

Gord

>Yah there is a little more to it.  See Attachment for details about how
>the dates show up in the drop down menu.
[quoted text clipped - 3 lines]
>|Download: http://www.excelforum.com/attachment.php?postid=4958     |
>+-------------------------------------------------------------------+
rbrickl - 29 Jun 2006 22:12 GMT
Sorry.  Here is the same thing again.  // Stands for the bring down
function.

Date //      Account //      Price //   Department //

6/12/2006        B3433    487.99      Frank
6/13/2006        B3433    432.99      Gregory
6/14/2006        C2354    325.34      Frank
6/23/2006        C2322    3423.23      Frank
7/12/2006        B3433    43.33      Harvy
7/23/2006        B3433    4335.32      Tammy
8/23/2006        C2342    324.34      Harvy

Date has bring down box that says:

(All)
(Top 10)
(Custom)
6/12/2006
6/13/2006
6/14/2006
6/23/2006
7/12/2006
7/23/2006
8/23/2006

I want it to say:

(All)
(Top 10)
(Custom)
June
July
August

With the same dates still in the table like now.

Signature

rbrickl

Gord Dibben - 29 Jun 2006 22:42 GMT
From your description, it seems you did not create the drop-down menu, you
simply have Autofilter turned on.

Autofilter list will show exactly what is in the cells.

You cannot change this AFAIK

You can use the Custom to extract only the month you wish to see.

Gord

>Sorry.  Here is the same thing again.  // Stands for the bring down
>function.
[quoted text clipped - 32 lines]
>
>With the same dates still in the table like now.
Roger Govier - 29 Jun 2006 22:51 GMT
Hi

I think the only way to achieve what you want would be to insert a new
column A.
In cell A2 enter =B2 and Format>Cell>Number>Custom>mmm
Copy down column A for the extent of your data.
Extend your Autofilter range to include the newly inserted column A.
Use the dropdown on column A to Select the Month required.

Signature

Regards

Roger Govier

> Sorry.  Here is the same thing again.  // Stands for the bring down
> function.
[quoted text clipped - 32 lines]
>
> With the same dates still in the table like now.
rbrickl - 30 Jun 2006 14:34 GMT
Am I in the right forum or not.  I think I should go to a more exper
one.  Anyways will someone please help me with my delema
rbrickl - 30 Jun 2006 14:40 GMT
Am I in the right forum or not.  I think I should go to a more expert
one.  Anyways will someone please help me with my delema.

Signature

rbrickl

Roger Govier - 30 Jun 2006 23:09 GMT
> Am I in the right forum or not.  I think I should go to a more expert
> one.

Fine

Just because you don't like the answers you have been given, doesn't
mean they are incorrect.
Have fun elsewhere.

Signature

Regards

Roger Govier

> Am I in the right forum or not.  I think I should go to a more expert
> one.  Anyways will someone please help me with my delema.
Gord Dibben - 01 Jul 2006 00:30 GMT
I think you should go to a more expert forum.

Changing what you see in the drop-downs of Autofilter is beyond us.

Gord

>> Am I in the right forum or not.  I think I should go to a more expert
>> one.
[quoted text clipped - 4 lines]
>mean they are incorrect.
>Have fun elsewhere.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.