Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Remove Dropdown Space

Posted on 2013-01-20
2
Medium Priority
?
273 Views
Last Modified: 2013-01-20
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
0
Comment
Question by:Rayne
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 38799278
=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
 

Author Comment

by:Rayne
ID: 38799308
Perfect Ssaqibh :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question