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…

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…

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…

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…

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…

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…

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…