Excel drop down list

Closed
Raj - Nov 7, 2011 at 07:42 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2011 at 09:35 AM
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

1 response

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