Excel drop down list

Closed
Raj - 7 Nov 2011 à 07:42
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Dec 2011 à 09:35
Hello,

My question is regarding drop down list in excel. If i have data of all 12 month. and i have created a drop down list in excel of all 12 month (i.e. All, Jan, Feb, Mar... Dec..) and i want to show data through drop down list. if i will select Mar then only march data will show and the other data will not show.

Example..
Drop down list... (All, Jan, Feb....Dec)

Name Dept. Publisher Date Status
ABC Production XXX 02/26/2011 Done
DEF Production XXX 02/02/2011 Done
GHI Production YYY 11/07/2011 Done
JKL Production ZZZ 03/07/2011 Done
MNO Production YYY 03/07/2011 Done

So in above example if i will section march in drop down list then only last two entry will be show... Is it possible on same location or on another sheet using formulas...

Kind Regards,
Rajesh
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Dec 2011 à 09:35
You can use filter for that