Category: Excel Tricks

Lesson#131: Find out complete blank rows in data sheet

In this post I will show you a simple trick by which you can find out complete blank rows in data sheet. I have made an arbitrary sheet to describe. I have to find out only complete blank rows in

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#127: Trick to make a color picker with VBA

An easy and simple trick to make a color picker will be shown here. Here I have made a color palette by coloring different cell with different colors. This palette allows us to pick different type of color by selecting

Lesson#126: Making a simple color tester with VBA

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#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#114: How to highlight cells with text or non-text values

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 array which contains both text and non-text values. What you have to do when you need

Tagged with: , ,

Lesson#113: How to highlight cells with errors in it

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 contains errors. If you need to highlight those cells

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

Lesson#111: Extract parts of text separated by special character

Here I will show you how to extract parts of text separated by a special character. In the above image I am having some structure id. Each text have four parts separated by “/”. Each parts has a different meaning.

Tagged with: , , , , ,

Lesson#110: Separate characters from text where any word appears

Here I will show how to separate characters from text where any text appears. Here in the above picture I am having some text values which contains the word “made”. I will show you how to part out text value

Tagged with: , , , ,
Top