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 attached with data on left side and results wanted on right side
TIA
8 Replies
- 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.
I'll try to solve this puzzle and refer back to you if I got the solution!
- thanks a lot mate
Hi,
You may not need to use the VBA!
Please check out this https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/.
Hope that helps
