Category: Excel Funtions

By Posted on Posted in Excel Features, Excel Funtions, Excel general tips No Comments Tagged with

Here I will share general tips about Conditional Formatting and some Information functions. These functions are ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT. You can use these functions to highlight the specified types of values among an array. ISBLANK function highlights blank cells among an array of …

Lesson#115: Information functions with Conditional Formatting Read more »

By Posted on Posted in Excel Funtions, Excel Tricks No Comments Tagged with , ,

We will discuss how to highlight text values or non-text values among an array. In the above picture, I have shown an example of the array which contains both text and non-text values. What do you have to do when …

Lesson#114: How to highlight cells with text or non-text values Read more »

By Posted on Posted in Excel Funtions, Excel Tricks 1 Comment Tagged with , ,

Here I will discuss an interesting formula. With this formula, we can calculate the percentage of a text matching another text. In the above picture, I have shown two cells. The first cell has a long text value and the …

Lesson#112: Calculate the match percentage of text which matches another text. Read more »

By Posted on Posted in Excel Funtions, Excel Tricks No Comments Tagged with , , , , ,

Here I will show you how to extract parts of text separated by a special character. In the above image, I am having some structure id. Each text has four parts separated by “/”. Each part has a different meaning. …

Lesson#111: Extract parts of text separated by a special character Read more »

By Posted on Posted in Excel Funtions, Excel Tricks No Comments Tagged with , , , ,

Here I will show how to separate characters from the text where any text appears. Here in the above picture, I am having some text values which contain the word “made”. I will show you how to part out text …

Lesson#110: Separate characters from the text where any word appears Read more »

By Posted on Posted in Excel Features, Excel Funtions, Excel general tips No Comments Tagged with , , , ,

Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …

Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »

By Posted on Posted in Excel Features, Excel for Office, Excel Funtions, Excel Tricks No Comments Tagged with , ,

Here in this post, I will show you how to hyperlink all files and folders in the worksheet within a minute. This can be done very easily. Often we need to make the summary of soft copies and link those …

Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more »