Excel drop down list

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use filter for that