IFERROR function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/iferror-function/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:02:19 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png IFERROR function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/iferror-function/ 32 32 Avoid these 7 Common Errors in Microsoft Excel (and how to fix them) https://www.xelplus.com/fix-excel-formula-errors/ Thu, 17 Feb 2022 10:00:00 +0000 https://www.xelplus.com/?p=9476 How do you fix broken Excel formulas? What do you do when the formulas return errors? Find out what the most common Excel formula errors are and how you can fix them. It's easy! You just need the right approach. This post covers it all!

The post Avoid these 7 Common Errors in Microsoft Excel (and how to fix them) appeared first on Xelplus - Leila Gharani.

]]> Top Excel Functions for Engineers https://www.xelplus.com/excel-for-engineers/ Thu, 23 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=9605 If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers 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.

]]> Extract Unique Items for Dynamic Data Validation Drop-Down List https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/ Fri, 05 Jan 2018 14:19:00 +0000 https://www.xelplus.com/?p=11193 Learn how to extract unique items from a list that contains multiple instances of each item, and use this list in a dynamic dropdown so that any time the list expands, your data validation list is updated. The solution will work in any Excel version, no Office 365 required.

The post Extract Unique Items for Dynamic Data Validation Drop-Down List appeared first on Xelplus - Leila Gharani.

]]>