Excel Array Formula - Free Excel Tutorial

How to Count Numbers with Leading Zeros

This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »

Check if Cell Contains Certain Values but do not Contain Others Values

In the previous post, we only talked that how to check a cell if contains one of several values from a range in excel. And this post explains that how to check a cell if it contains certain values or contains one of several values but do not contain other certain values in another range… read more »

How to get first match that cell contains one of several values in a range

This post explains that how to get the first match that cell contains one of several values from another range or a list in excel. before we talked the way that how to check a cell to see that if it contains one of several values in a range or list using the SEARCH function… read more »

How to Split Text String to an Array

This post explains that how to convert the text to an Array in excel. How to convert text into array using formula in excel 2013? How to split the text string into an array where the each character in text is an element in array using excel formula in excel 2013. How to split text… read more »

Sidebar