INDEX function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/index-function/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 12:06:20 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png INDEX function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/index-function/ 32 32 How to Use Radio Buttons in Excel to Create Interactive Dashboards https://www.xelplus.com/excel-dashboards-with-radio-buttons/ Thu, 17 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9999 Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Radio Buttons in Excel to Create Interactive Dashboards appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s STOCKHISTORY Function https://www.xelplus.com/excel-stockhistory-function/ Thu, 28 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=8967 The StockHistory Function in Excel allows you to easily pull historical stock data in Excel with a single formula. You can get daily, weekly or monthly data. Find out how to use this together with sparklines to visualize the trend of different stocks in one view.

The post How to Use Excel’s STOCKHISTORY Function appeared first on Xelplus - Leila Gharani.

]]> When to Use the Hash Sign (#) in Excel Formulas https://www.xelplus.com/excel-hash-sign-formulas/ Thu, 21 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10332 What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas 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 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 Get Multiple Match Results in Excel Without the FILTER Function https://www.xelplus.com/excel-multiple-match-results-complete/ Thu, 28 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11320 If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your problem best.

The post How to Get Multiple Match Results in Excel Without the FILTER Function appeared first on Xelplus - Leila Gharani.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns 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.

]]> First Excel Hash Challenge between 6 MVPs https://www.xelplus.com/excelhash_1/ Tue, 04 Sep 2018 08:33:00 +0000 https://www.xelplus.com/?p=10431 This Chick's Trouble is my recipe for Excel Hash. It includes the FREQUENCY & MAX functions, 3D Models & Form Controls. You'll be surprised what comes out...

The post First Excel Hash Challenge between 6 MVPs appeared first on Xelplus - Leila Gharani.

]]> Return Multiple Match Values in Excel https://www.xelplus.com/return-multiple-match-values-in-excel/ Thu, 30 Aug 2018 10:26:00 +0000 https://www.xelplus.com/?p=9715 What to do when VLOOKUP falls short? It can't return multiple match results. But there are formulas that can. Here, I show you 2 different methods that return multiple matches: a combination of INDEX & AGGREGATE, which are available in all Excel versions, and TEXTJOIN, which was first introduced in Excel 2016 and Office 365.

The post Return Multiple Match Values in Excel appeared first on Xelplus - Leila Gharani.

]]>