Flexible and conditional drop-down list

rookie_excel

New Member
Joined
Jun 7, 2019
Messages
2
Hi everyone,

I am working for a project for my company and would need some help on an issue I have.

Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields.

I am working with conditional drop-down lists in order to retrieve data that is linked to a SUMIF formula. Even though it is a good start it does not offer me the full flexibility of a PivotTable since the lists are conditional on each other. Let's say that if I have 10 different drop-down lists in Column A to J and the different drop-down lists are dependent on each other. Is there a way I can structure it so that at any point I can retrieve the data based on just column A and D and at the same time just a single column?

If for example, Column A = Country), B = Month), C = Product), D = Area

Column A includes: Germany, Spain and Australia
Column C includes: Coca Cola, Fanta and Water

I want to have the possibility to see the sales for Coca Cola in Germany, but at the same time, I want to have the possibility to see the total sales for Coca Cola based on all the different countries in the drop-down list. Is there a way in which this can be achieved?

I know it works in a PivotTable but I want to know if it's possible achieve the same flexibility by building a model and not using IF function because the database is to large for building such a formula.

Thankful for any suggestions!
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,237
Last edited:

rookie_excel

New Member
Joined
Jun 7, 2019
Messages
2
Hi Yongle,

Thanks for your reply, that's exactly what I did. Do you happen to know if it is possible to link formulas to the slicers?

Thank you
 

Forum statistics

Threads
1,077,668
Messages
5,335,579
Members
399,026
Latest member
Im_Stupid

Some videos you may like

This Week's Hot Topics

Top