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...
thanks mate, but how to get the common values part of the puzzle?
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