Tag: IF
Lesson#135: MAXIF and MINIF with function IF
In this post, I will show you to make two new functions. These are functions MAXIF and MINIF. It means this formula will show the Maximum or the Minimum value when the criteria will be matched. Here I have put …
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 formula auto numbering because it helps to create automatic serial numbers. Now I am showing you these formulas with an …
Lesson#132: How to make the function SUMPRODUCTIF
In this post, I will show you the trick to make the function SUMPRODUCTIF. We have the SUMPRODUCT function in excel. But how to make a SUMPRODUCT function that follows criteria like SUMIF? Here I have made an example. Here’s …
Lesson#132: How to make the function SUMPRODUCTIF Read more →
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 to filter …
Lesson#128: Formula to make serial no auto arranged when filtered Read more →
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 …
Lesson#117: How to split up characters of text in excel Read more →
Lesson#112: Calculate the match percentage of text which matches another text.
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 →
