SUBSTITUTE Archives - Xelplus - Leila Gharani

Top Excel Functions for Engineers

Leila Gharani — Thu, 23 Dec 2021 10:00:00 +0000

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 a Recursive LAMBDA Works

Leila Gharani — Thu, 17 Dec 2020 10:00:00 +0000

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 2, we will create a Lambda function that can reference itself.

The post How a Recursive LAMBDA Works appeared first on Xelplus - Leila Gharani.

How to Remove Non-breaking Spaces in Excel Data – Get Rid of ALL Stubborn Spaces

Leila Gharani — Thu, 30 Jan 2020 10:00:00 +0000

Sometimes the data you copy or import into Excel has stubborn spaces that can't be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.

The post How to Remove Non-breaking Spaces in Excel Data – Get Rid of ALL Stubborn Spaces appeared first on Xelplus - Leila Gharani.

Lookup Values Across Multiple Worksheets in Excel

Leila Gharani — Fri, 17 Nov 2017 07:40:00 +0000

In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

The post Lookup Values Across Multiple Worksheets in Excel appeared first on Xelplus - Leila Gharani.