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…

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

Top