Tag: IF

Lesson#135: MAXIF and MINIF with function IF

In this post I will show you to make two new functions. These are function MAXIF and MINIF. It means this formula will show the Maximum or the Minimum value when a criteria will be matched. Here I have put

Tagged with: , ,

Lesson#133: Auto numbering formulas in Excel

Hello friends. I am back with another interesting lesson. How to make auto numbering formulas in Excel. I named that formulas auto numbering because it helps to create automatic serial numbers. Now I am showing you these formulas with an

Tagged with: , , , , , ,

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#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: , ,

Short Tips#0055: Formula to find closest value in an array from higher side

Tagged with: ,

Short Tips#0054: Formula to find closest value in an array from lower side

Tagged with: ,

Short Tips#0003: Finding exact middle character(s) of text

Tagged with: , , ,

Lesson#87: How to make month wise auto updating program schedule

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating gantt chart without using excel chart It was a day wise scheduling format. Here I will show how to make a month wise scheduling format. First

Tagged with: , , , , , ,
Top