114,892 views
Follow us on our Telegram channel: https://t.me/BeProOo Be Professional Group on Facebook: / 166426910643767 Explanation of the Offset function in creating sequential drop-down lists • Sequential drop-down lists using D... Explanation of creating lists using the Indirect method • Linked drop-down lists in Excel... Explanation of the Unique function: • The equation for obtaining non-duplicate values U... Explanation of the Filter function: • The Filter function and its amazing capabilities Download the work file: https://cutt.ly/YmHVnMt =========== Video timeline 00:00 Introduction 01:32 Preparing the data 02:52 Creating the first drop-down list 06:20 Creating the second drop-down list 08:42 Creating the third drop-down list 09:42 Creating the fourth drop-down list 11:31 Explanation of why this method is not always used =========== Follow us on our website www.BePro.training Follow us on social media: Facebook: / almfs Twitter: / almunthir LinkedIn: / almunthir BePro Page: / be.prooo Telegram: https://t.me/BeProOo Twitter: / bepro19 Cascading dropdown list Dependent dropdown list