wildcards Archives - Xelplus - Leila Gharani

Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks)

Leila Gharani — Thu, 05 Mar 2020 10:00:00 +0000

Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

How to Use Excel XLOOKUP Function – 5 Examples

Leila Gharani — Thu, 28 Nov 2019 10:00:00 +0000

Excel's New & Improved XLOOKUP function will be the answer to most of your Excel Lookup problems. Learn from these 5 examples to see how you can apply the new XLOOKUP function to your files.

The post How to Use Excel XLOOKUP Function – 5 Examples appeared first on Xelplus - Leila Gharani.

Excel Function to Check IF a Cell Contains Specific Text

Leila Gharani — Sat, 01 Jun 2019 22:31:00 +0000

How can you use wildcards in Excel's IF Function - with this method you can easily check for a partial text match. It's a clever method to get the IF function to check if the cell value contains a word.

The post Excel Function to Check IF a Cell Contains Specific Text appeared first on Xelplus - Leila Gharani.

Excel SUM based on Partial Text Match (SUMIFS with wildcards)

Leila Gharani — Wed, 28 Nov 2018 21:22:00 +0000

SUMIFS is great for summing values based on a condition. But did you know you can also sum values based on a partial text match? Find out more in this post.

The post Excel SUM based on Partial Text Match (SUMIFS with wildcards) appeared first on Xelplus - Leila Gharani.

Excel VBA: Check If File or Folder Exists (DIR)

Leila Gharani — Thu, 22 Nov 2018 15:18:00 +0000

Discover how the DIR function works in VBA. It returns a string that represents a directory or file that matches a defined pattern. This is helpful when you need to refer to other files or folders in your macro. You can also check if a folder exists, and if it doesn’t, create a new folder in the directory.

The post Excel VBA: Check If File or Folder Exists (DIR) appeared first on Xelplus - Leila Gharani.