How to Sum Values Between Two Dates using SUMIFS

How to Sum Values Between Two Dates (SUMIF Between Dates)Yes, you heard it right, using SUMIFS is the easiest and the best method to sum values between two dates (i.e. a range of dates).Let’s say, you are working in a trading company and your boss asks you to get the total sales amount for last […]

How to use SUMIF with Wildcard Characters in Excel

SUMIF is one of my favorite Excel functions and I’m sure it’s yours also.But one thing which I always worry about it, we can only sum values when criteria fully match with values.Let’s say, your name is John Martin.In this case, if we want to sum values using your name we should have your full […]

How to Calculate SQUARE ROOT in Excel + [Insert Symbol]

Excel is like a Swiss army knife for calculations.From mathematical to financial, it’s for every single thing you need to calculate. You can calculate simple to most complex things in Excel. Take an example of SQUARE ROOT.A square root is a quite common calculation which we do in our day to day work, and in Excel, […]

VBA Codes to Highlight Duplicate Values in Excel

While working with huge data, duplicate values are always a concern. Most of the time I use remove duplicate option to remove all those values.And, I’m sure you do the same.But, removing these duplicate values or just counting them never sort out the problem. The important thing is to review all the duplicate values before […]

How to Extract Hyperlink Address (URL) in Excel Using VBA UDF

Let’s say you got an Excel workbook from your colleague where you have a list of hyperlinks in a column.Now from this list, you want to extract all the hyperlink URL addresses.The manual method is a real pain, you need to copy-paste each URL one by one.So the better way is to create a UDF […]