Excel, Accelerated: Expandable conditional dropdown lists from nonadjacent ranges

Time: 02:4 | Would you like to learn Expandable conditional dropdown lists from nonadjacent ranges? To learn how, watch the video and download the Excel template. Acceleration Techniques: Technique: Upper and lower fences Technique: Data validation