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,650
Messages
5,335,493
Members
399,019
Latest member
prab1101

Some videos you may like

This Week's Hot Topics

Top