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…

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: COUNTIF, DATE, EOMONTH, FIND, FORMULATEXT, IFERROR, INDIRECT, LEN, MID, MONTH, NOT, SUBSTITUTE, WORKDAY.INTL, YEAR

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

Top