How to use VLOOKUP with multiple criteria in excel?
VLOOKUP is very handy When you have a particular data in hand, and you need to find…
VLOOKUP is very handy When you have a particular data in hand, and you need to find…
While you are working in excel, a time comes when you need to work at a fast…
Pad text to equal length: When we are dealing with loads of cells which have data filled in it, we observe that due to the length of different data’s (or characters together) they seem very inappropriate.
When you are weak in math, even a cube root becomes a huge deal🙅! So, to find…
If you are looking for a way where you could convert feet and inches into inches through…
If you want to find out the name from an email address, you have walked into the right place😏. To find the same, all you need is the LEFT Function and FIND Function.
If you have two timings⏳ in your screen and you want to calculate the difference between them…
If you want to count the unique values in a range, you can do the same with the help of SUMPRODUCT Function and COUNTIF Function.
When you have a bunch of dates and all you need is to get the month out of it, here’s what you can do: