As you know, a time value is a numeric value which is formatted as a time but when you deduct one value from another it returns a decimal number and you need format it again as time […]

Let’s say you are preparing a data where user’s age is one of the important things to capture. The thing is, if you ask every user to enter his/her age, chances are they can give you an approx number.

INDEX MATCH, when combined, can change the approach you use to lookup values in Excel.Yes, you get it right.The combination of these two functions can match the gap of all other functions which we use for lookup.Let me tell you how.If you love to use VLOOKUP then I’m sure you have this secret pain inside: […]

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

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