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#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#107: How did I add MS Project features in Excel project schedule

Here I will discuss a long topic about Excel gantt chart making. I will show how I made my excel chart work like ms project schedule by adding some basic features. Some basic features of ms project which I added

Tagged with: , , , , , , , , , , , , ,

Lesson#103: Ways to find duplicate values in a worksheet

Often we need to find the duplicate values in Excel worksheet. Here in this post I will discuss some methods to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT Excel MODE function returns the most frequently occurring

Tagged with: , , , ,

Short Tips#0031: COUNTIF application on date

Tagged with: ,

Short Tips#0030: COUNTIF application on numbers

Tagged with: ,

Short Tips#0027: How to count cells containing any part of text

Tagged with:

Short Tips#0026: How to count cells having value between two dates?

Tagged with:

Lesson#49: Make a parent gantt chart from a data table

Here I have to make a parent gantt chart from a data table. It is a gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value

Tagged with: , , , , ,

Lesson#46: Count cells which contain any text or part of that text

This character “*” (Asterisk)  is used to denote any text within a cell. 1. If you use the formula =COUNTIF(range, “*”) then it will count  the numbers of cell having any text within range. 2. If you use =COUNTIF(range, “CEMENT*”)

Tagged with: