Forum Discussion
Range of arrays and mutilple drop down filter options
This is how the output is based on multilple filter selections above.
This is how data is available by months and transcation type
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 data needs to be summarised by transaction type which is already set.The only dynamic part is the period which the user can select .I have already set data validation field with multilple filter options for the period .Which excel formula can i use for the financial data to be extracted by period.I have a tried IF formula but the period combinations are huge and excel formula length is crazy.Is there any simplified way of extracting this information??
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.
