Forum Discussion
cascading dropdown and common list
Hello friends, I am new to excel and VBA, kindly let me know how to filter second drop down based on value selected in first dropdown + how to get common values ? please see example excel att...
Hi,
I got an easy solution using a different approach, it's away from VBA and even formulas!
This can be done by using the Pivot Table as shown in the below screenshot:
In the Pivot Table, you can easily summarize and filter the data using visual slicers rather than drop-down lists.
Also, you can a conditional formatting rule to show up the most common values in a color gradient scale.
Please find the attached file.
Regards
thanks mate, but how to show the common existing values for example for Sydney and operations only ops123 and ops456 are common for employees 100,200&300. so only ops123 and ops 456 are to be shown.
Okay, I've updated the attached workbook with the possible solution!
But this time I used some formulas along with the Pivot Table to do this.
Hope that helps