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 …
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 …
In this post, I will show you a simple trick by which you can find out complete blank rows in the Excel datasheet. I have made an arbitrary sheet to describe. I have to find out only completely blank rows …
Lesson#131: Find out complete blank rows in the Excel datasheet Read more »
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 »
An easy and simple trick to make a color picker will be shown here. Here I have made a color palette by coloring different cells with different colors. This palette allows us to pick different types of colors by selecting …
Lesson#127: Trick to make a color picker with VBA Read more »
Here I will show you how to make a simple color tester with VBA. This color tester is having only one big button. It will take input from the user for the value of Red, Green, and Blue. Then it …
Lesson#126: Making a simple color tester with VBA Read more »
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 »
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 the array which contains both text and non-text values. What do you have to do when …
Lesson#114: How to highlight cells with text or non-text values Read more »
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 contain errors. If you need to highlight those cells …
Lesson#113: How to highlight cells with errors in it Read more »
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 »