Hi,
Hopefully someone can help with completing this array formula for me.
I have attached a sample of data I am using. The data in C1:C5 is the output from a multiple selection combo box. This is then translated to the data in E1:E5 (so sometimes there are only 1 result or sometimes five results. I am then using this information as part of the formulas shown in C10:C13. The CSE formulas I am using work but I couldn't figure out how to incorporate the options in B7 (highlighted in RED) that I now have to add to this file. These options don't actually appear in the data itself but summarise Column D in the DATA tab as follows:
All Bands - All the Deal Bands
Band 3+ - only Bands 3 and 4
Band 0-2 - only Bands 0,1 and 2
I figure I need to incorporate nested IF Statements into my formula but have failed to make anything work. If there are other ways of doing this, I am willing to consider them.
Thanks for your help
Regards
Al
Bookmarks