Remove Dropdown Space

Hello,

Previously,
I got a solution from here:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28002175.html


I want to dynamically show only the applicable months as choices and no spaces in the month dropdown option. How do I change the offset function in DV to do that?
For example : if I select Quarter = Q2 and month  = M6, I am seeing this:
W23,W24,W25,W26 and a space in the dropdown.
How do I eliminate that extra space?

See attached image…
spaceINDropDown.png
RayneAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=OFFSET($L$10,MATCH($C$3,$L$11:$L$22,0),1,1,COUNTA(OFFSET($L$10,MATCH($C$3,$L$11:$L$22,0),1,1,5)))
0
 
RayneAuthor Commented:
Perfect Ssaqibh :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.