Dependent Dropdown Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dependent-dropdown/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:31:10 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Dependent Dropdown Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dependent-dropdown/ 32 32 How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Setup Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-dependent-drop-down-lists/ Tue, 08 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10395 Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

The post How to Setup Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Dependent Drop Down Lists on Many Rows https://www.xelplus.com/excel-dependent-drop-down-every-row/ Thu, 26 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11410 Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.

The post How to Create Excel Dependent Drop Down Lists on Many Rows appeared first on Xelplus - Leila Gharani.

]]> Reset Dependent Drop-down in Excel https://www.xelplus.com/reset-dependent-drop-down/ Fri, 14 Dec 2018 00:07:00 +0000 https://www.xelplus.com/?p=9318 Excel data validation dependent drop-down values don't automatically reset once you change the value of the first drop-down. Learn how to quickly reset this with a tiny bit of VBA.

The post Reset Dependent Drop-down in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Dependent Combo Box Solves an Annoying Problem https://www.xelplus.com/dependent-combo-box/ Sat, 08 Dec 2018 01:41:00 +0000 https://www.xelplus.com/?p=9841 Combo boxes are a good alternative to data validation drop-down lists in Excel. Learn how to create a dependent combo box in Excel. This combo box ends up solving an annyoing Excel "reset" problem.

The post Excel Dependent Combo Box Solves an Annoying Problem appeared first on Xelplus - Leila Gharani.

]]> Excel Dynamic Arrays – Excel will never be the same https://www.xelplus.com/excel-dynamic-arrays-how-excel-will-change/ Tue, 30 Oct 2018 04:06:00 +0000 https://www.xelplus.com/?p=9576 With the new Excel Dynamic Arrays, we can solve complex tasks with simple formulas. Find out just how much time and frustration you end up saving by being able to Filter, Sort and quickly find Unique values.

The post Excel Dynamic Arrays – Excel will never be the same appeared first on Xelplus - Leila Gharani.

]]> Expandable Conditional Drop Down Lists in Excel https://www.xelplus.com/excel-dynamic-dependent-drop-down-lists-exclude-blanks/ Fri, 20 Jul 2018 07:16:00 +0000 https://www.xelplus.com/?p=10085 Quickly create dynamic drop-down lists in Excel that are dependent on another list. Automatically exclude blank cells and allow the drop-down to expand as new values are added.

The post Expandable Conditional Drop Down Lists in Excel appeared first on Xelplus - Leila Gharani.

]]> Find Multiple Matches in Excel & Create a Dependent Drop Down List https://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/ Thu, 15 Mar 2018 10:38:00 +0000 https://www.xelplus.com/?p=11023 In this tutorial, we will create a dependent drop-down list based on a messy Excel Table. For that purpose, we will extract all records for each category using the combination of INDEX and AGGREGATE. Next, we will fix the column referencing in the table. Finally, we will use a combination of OFFSET and COUNTIF to get a drop-down list restricted to non-empty cells.

The post Find Multiple Matches in Excel & Create a Dependent Drop Down List appeared first on Xelplus - Leila Gharani.

]]> Excel Dependent Drop Down List with Tabular Data https://www.xelplus.com/excel-dependent-drop-down-list-tabular-data/ Thu, 09 Nov 2017 19:45:00 +0000 https://www.xelplus.com/?p=11799 How do you create conditional lists without name manager? You can use the offset formula directly in the data validation box. Watch this video to find out how.

The post Excel Dependent Drop Down List with Tabular Data appeared first on Xelplus - Leila Gharani.

]]> Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List https://www.xelplus.com/excel-dependent-drop-down-lists-multiple-words-spaces/ Wed, 01 Nov 2017 14:32:00 +0000 https://www.xelplus.com/?p=11820 See how to set up a dependent dropdown list. In this example, the first dropdown list is the column headers of a table, and depending on what the user selects, that will define the contents of the second dropdown.

The post Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List appeared first on Xelplus - Leila Gharani.

]]>