SUMPRODUCT is one of the most important Excel functions and the best part about it is, you can modify it in several ways.And, one of its powers which I have discovered recently is using it as “SUMPRODUCT IF”.In short, a Conditional SUMPRODUCT.As you know, you can use SUMPRODUCT to multiply and sum specified ranges or […]

The best part of conditional formatting is you can use formulas in it.It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE.If that formula returns TRUE, conditional formatting will apply and if it returns FALSE, conditional formatting will not apply.The […]

How to Automatically Add Serial Numbers in ExcelExperts know the importance of serial numbers. Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless. Yes they are important.Because with a serial number you can have a unique identity to each entry of your data. But the sad news is, adding them […]

Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations instead of formulas.In paste special, you have four different options [Add, Subtract, Multiply, and Divide] which you can use.And today in this post, I’d like to show you how can you use paste special to […]

Top 100 Useful Excel Macro [VBA] Codes ExamplesMacro codes can save you a ton of time. You can automate small as well as heavy tasks with VBA codes.And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has?So today, I have listed some of […]