By using the SUMIF function you can sum values based on a single condition or criteria like other cells being equal to either one value or another. You can use ...

In a large worksheet, there remains a possibility of having empty rows. From this article, you will get to know how to remove empty rows in excel. To make ...

Sometimes when data is copied from another source then there is a possibility of having a couple of information compact together. For this type of problem ...

If in a large dataset multiple information are compacted in one cell, then it is hard to find and lookup data to view or to do any task. In this article, I’m ...

To perform any data analysis task comparing data in excel rows is common. It is most required for banks to check the background of a customer depending on the ...

In a worksheet, you may need to fill color in different cells depending on the formula used in the sheets. I’m going to explain different ways of how to fill ...

By using fill across you can fill contents, formats, and both from multiple sheets which is an easy and quick way to copy format and contents across sheets. In ...

In a large dataset, there is a possibility of having some null or blank cells. SUM function doesn’t work with #N/A values but there are several ways to do SUM ...

Whenever someone may need to lookup values depending on multiple criteria from a large worksheet then you can use some functions to do it. XLOOKUP is one of ...

Whenever someone needs to calculate the average of VLOOKUP values from a worksheet then you can use some functions. In this article, I’m going to explain how ...

While creating a large worksheet it is very much possible to have some extra spaces in the contents. To make an excellent worksheet it is needed to remove ...

Sometimes, you may need to count the months in a column to see in the same month which projects or works are running or had been happened. In this article, I’m ...

When we want to keep track of a particular project and work, and many more then it is important to count the months. To keep track we need to count the month ...

Select is one of the most needed tasks of Excel. While performing functions or formulas in multiple rows we may require to select every other row. In this ...

It may need to extract data by comparing three columns or to get an insight of data we may need to compare three columns. In this article, I’m going to explain ...