Latest Posts

How to Compare Addresses in Excel (11 Easy Methods)

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 ...

IFERROR with VLOOKUP in Excel (5 Different Uses)

When the VLOOKUP function can’t find the lookup value in the lookup array, it will show an error sign, #N/A. But you can get rid of this problem by ...

How to Delete All Rows Below a Certain Row in Excel (6 Ways)

If you are looking for some of the easiest ways to delete all rows below a certain row in Excel, then you are in the right place. By following the ...

VBA to Delete Entire Row based on Cell Value in Excel (3 Methods)

Sometimes we need to remove an entire specific row from a huge dataset of rows in Excel. When the cells in the dataset are carrying values, then we ...

SUMIF with Multiple Criteria for Different Columns in Excel

This article is all about how to SUMIF with multiple criteria for different columns in Excel. While working with Excel, sometimes we need to ...

How to Sum Colored Cells in Excel (4 Ways)

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. Yet multiple ways can manage to sum up the cells based on ...

How to Calculate Horizontal Running Total in Excel (3 Ways)

A running total is the total of a series of numbers that updates each time a new number is added to the sequence. It can be calculated by summing up ...

Does TABLE Function Exist in Excel?

In Microsoft Excel, a Table is a tremendously instrumental tool to process large amounts of data with ease. It saves a lot of time and reduces a lot ...

Cumulative Sum in Excel If Condition Applied (6 Methods)

Cumulative summation is one of the most used operations throughout the world to keep track of data related to similar things. Cumulative summation ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Calculate Running Total in Excel (9 Ways)

If you are looking for some of the easiest ways to calculate the running total in Excel, then you will find this article useful. Running total means ...

How to Remove the First Character from a String in Excel with VBA

In this article, I will show you how you can remove the first character from a string in Excel with VBA. You’ll learn two easy procedures to remove ...

Remove Last Character from String Excel (5 Easy Methods)

In instances, we come across additional data attached to the right of entries. We badly want to remove them. But doing it manually is a hideous task. ...

How to Fill Color in Excel Cell Using Formula (5 Easy Ways)

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 ...

SUMIFS Multiple Criteria Along Column and Row in Excel

Excel is part and parcel of our daily life. When we think about data, the first thing that comes to our mind is Excel. We can do all sorts of data ...

ExcelDemy
Logo