Forum Discussion
Range of arrays and mutilple drop down filter options
[ Spoiler ] Iam trying to extract some financial data which is available by periods (by months) and transaction type (Rev,GM,SGA,OM) and the user can filter by month or select mutilple periods and d...
You don't really give sufficient information to be fully confident in answering. As a preliminary observation, let me just say that the FILTER function (as opposed to the tool bar Filter) does allow for quite a few combinations, thus obviating the need for deeply nested IF functions. If you've already tried that and found it lacking, might I suggest you return and give us a bit more to work with.