Combine Data Validation, Named Ranges and the Indirect Formula to customise your drop-down list!

Описание: I love it when Excel tips and tricks combine to make a useful example.
Here we wanted our Data validation to work with our named ranges - it's easy once you know how!
#365traininghub #microsoftexcel
Follow us for more tips and tricks across M365!