Category: Excel Funtions

Lesson#132: How to make the function SUMPRODUCTIF

In this post I will show you the trick to make the function SUMPRODUCTIF. We have SUMPRODUCT fuction in excel. But how to make a SUMPRODUCT fuction that follows criteria like SUMIF. Here I have made an example. Here’s how

Tagged with: ,

Lesson#128: Formula to make serial no auto arranged when filtered

Here I will show how to make auto arranged serial no when you filter a column. This post will be very useful to many excel users like me. Suppose you are using a data sheet and you need filter certain

Tagged with: ,

Lesson#117: How to split up characters of text in excel

Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula which

Tagged with: , ,

Lesson#115: Information functions with Conditional Formatting

Here I will share a 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 specified type of values among an array. ISBLANK function highlights blank cells among an array of values.

Tagged with:

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

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 array which contains both text and non-text values. What you have to do when you need

Tagged with: , ,

Lesson#113: How to highlight cells with errors in it

I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them I have some cells which contains errors. If you need to highlight those cells

Tagged with: ,

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

Here I will discuss a interesting formula. With this formula we can calculate percentage of a text matching with another text. In the above picture I have shown two cells. First cell having a long text value and the second

Tagged with: , ,

Lesson#111: Extract parts of text separated by special character

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 have four parts separated by “/”. Each parts has a different meaning.

Tagged with: , , , , ,

Lesson#110: Separate characters from text where any word appears

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

Tagged with: , , , ,

Lesson#106: How to lookup picture in excel

Okay friends here I will show you an interesting tricks about Excel. That is how to lookup picture in excel. We have  learned looking up values from a table but looking up picture from table is little different. Here in

Tagged with: , , ,
Top