How to Get Month from a Date in Excel

Dates are an important part of data.There are few times when we need to use only a part from a date. Take an example of the month.Sometimes you only need a month from a date.A month is one of the useful components of a date which you can use to summarize data and when it […]

➲ Continue Reading

COUNTIFS and COUNTIF With OR Logic

Two days back I wrote about how you can use OR logic in SUMIFS and SUMIF. And today, I want to show, that you can also use the same OR logic and multiple conditions in COUNIFS and COUNIF. Even you can create dynamic criteria for OR logic in COUNIFS and COUNIF. Have you ever faced a […]

➲ Continue Reading

Remove Extra Spaces

A clean data is our birthright. But sometimes, we are not able to access it. Sometimes, we are not able to use our data as the way we want. And, the of the one biggest reasons which make our data unable to use is extra spaces in a cell. So, if you want to use […]

➲ Continue Reading

SUMIF / SUMIFS with an OR Logic

Sometimes we need to make small amendments in formulas to make them more flexible and effective.Just like that, SUMIF OR is an advanced formula which helps you to increase the flexibility of SUMIF. Yes, you can also do SUMIFS OR.Let’s understand this first.In SUMIFS, you can use more than one criteria to get a sum […]

➲ Continue Reading

Ranks in a Pivot Table

By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc.One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each other.The […]

➲ Continue Reading