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 [...]
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 [...]
How to use SUMIF / SUMIFS with an OR Logic in Excel
Sometimes we need to make small amendments in formulas to make them effective.Just like that, SUMIF OR.It’s an [...]
Generate Random Letters in Excel
Ever faced a situation where you need to generate random letters? Yes, sometimes we need to generate random letters. [...]
Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]
First of all just do this for me, open your Excel workbook and try to type RANKIF.You will [...]
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.