Dropdown List Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dropdown-list/ 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 Dropdown List Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/dropdown-list/ 32 32 Create Searchable Drop-Down Lists in Excel with ZERO Effort https://www.xelplus.com/default-searchable-drop-down-lists-in-excel/ Thu, 27 Jan 2022 10:00:00 +0000 https://www.xelplus.com/?p=9525 It takes ZERO effort to now get searchable drop-down lists in Excel. Excel's data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

The post Create Searchable Drop-Down Lists in Excel with ZERO Effort appeared first on Xelplus - Leila Gharani.

]]> 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 Use the Google Sheets FILTER Function https://www.xelplus.com/google-sheets-filter-function/ Tue, 24 Nov 2020 12:00:00 +0000 https://www.xelplus.com/?p=10434 Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

The post How to Use the Google Sheets FILTER Function appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Searchable Drop-Down Lists for Every Row https://www.xelplus.com/excel-searchable-drop-down-every-row/ Thu, 16 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11372 Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row 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.

]]> Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) https://www.xelplus.com/searchable-drop-down-list/ Fri, 25 Jan 2019 16:16:00 +0000 https://www.xelplus.com/?p=12998 This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) 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.

]]> Data Validation in Excel https://www.xelplus.com/data-validation-in-excel/ Thu, 10 May 2018 16:46:00 +0000 https://www.xelplus.com/?p=10873 Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation 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 Dynamic Map with Drop-Down https://www.xelplus.com/dynamic-map-chart-with-drop-down/ Sun, 28 Jan 2018 21:41:00 +0000 https://www.xelplus.com/?p=11145 In case you're interested to visualize a KPI on a customized map in Excel which works on any version of Excel, then this tutorial is for you. I show you in easy steps how to find the right map and how to set it up properly.

The post Excel Dynamic Map with Drop-Down appeared first on Xelplus - Leila Gharani.

]]>