Category Archives for Formulas

How to Remove Extra Spaces in Excel

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 one of the biggest reasons which make our data unable to use is…So if you want to use it we need to remove them all.When you think […]

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

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

Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]

RANKIF: Conditional Ranking in Excel using SUMPRODUCTFirst of all just do this for me, open your Excel workbook and try to type RANKIF. You will be wondered that there is no function in Excel for conditional ranking. Yes, there is no one.Now, just think this way, have you ever faced a situation where you have to rank […]

Weighted Average in Excel

The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.