Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Category Archives for Formulas
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 ReadingRemove 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 ReadingSUMIF / 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 ReadingGenerate 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 […]
➲ Continue ReadingConditional 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 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 values by using some specific […]
➲ Continue Reading