And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.
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.
Yes, you heard it right……SUMIFS is the easiest and the best method to sum values between two dates......(i.e. [...]
SUMIF is one of my favorite Excel functions and I’m sure it’s yours also. But one thing [...]