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 …
Lesson#133: Auto numbering formulas in Excel
Hello friends. I am back with another interesting lesson. How to make auto numbering formulas in …
Lesson#132: How to make the function SUMPRODUCTIF
In this post, I will show you the trick to make the function SUMPRODUCTIF. We have …
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. …
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. …
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 …
Lesson#112: Calculate the match percentage of text which matches another text. Read more →
