How to use OR Logic in COUNTIF/COUNIFS in Excel

A few days back I wrote about how we can use SUMIF OR. And today, I want to show that by using same logic we can create a COUNT OR formula.Even we can create dynamic criteria in this formula.But first of all, let me ask you something.Have you ever faced a situation where you need […]

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 […]

How to use SUMIF / SUMIFS with an OR Logic in Excel

Sometimes we need to make small amendments in formulas to make them more flexible and effective.Just like that, SUMIF OR is an adanced formula which helps you to increase the flexibility of SUMIF.Yes, you can also do SUMIFS as well.Let’s understand one thing first.In SUMIF, you can only use one criterion and in SUMIFS, you […]

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 […]

Generate Random Letters in Excel

Ever faced a situation where you need to generate random letters? Yes, sometimes we need to generate random letters. We have functions like RAND and RANBETWEEN to generate random numbers but we don’t have any particular function to generate letters. But today, I will share with you an amazing formula trick to generate random letters in […]