Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …
Lesson#103: 4 Ways to find duplicate values in a worksheet Read more →
Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …
Lesson#92: How to highlight a column value depending upon the other column values Read more →
So here I will show you a simple but very useful trick with Conditional Formatting. This is about how to highlight a particular number in an array automatically. So in the above picture, I have a number array where I …
Lesson#90: How to highlight a particular number in an array automatically Read more →
Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format. First I …
Lesson#87: How to make month wise auto-updating program schedule Read more →
We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW()) 2. Select those cells one by one and click on Conditional Formatting>Data …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more →
Let me show you how to make a spreadsheet that changes its color every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the …
Lesson#79: Automatic changing Excel sheet color every second Read more →
Now I will show how to make a spreadsheet that changes its color every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of the sheet to select all of the spreadsheets. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more →
Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …
Lesson#77: Scope the breakup program schedule and explain the formula Read more →
This is a project schedule format where I have a list of dates and works. I need to color all the Sundays in the list of dates and for that, I will use a simple trick. Select all the dates …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once Read more →
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 …
Lesson#49: Make a parent Gantt chart from a data table Read more →