How to Get nth day of year in excel?
To calculate the no. of day in a year from a particular date, we will use the DATE Function and YEAR Function. Here’s an example, to elaborate the steps that…
Continue readingWe found 0 resources for you...
How to count cells without errors?
If you want to count the cells in the range that do not contain errors, then we can use the SUMPRODUCT Function, NOT Function, and ISERR Function. Let’s take an…
Continue readingHow to count characters total in a range?
To count the total characters, present in a particular cell, you can use the LEN Function. By characters we mean, anything present in the cell, be it the symbol, alphabet…
Continue readingHow to count data that ends with a particular value?
In this space, we will learn how to count data that ends with a particular value e.g. RSVPUP-12-P, here, P is the ending value of the cell. When you are…
Continue readingHow 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 something in relation to it, it becomes nearly impossible to look after it…
Continue readingFind Cube Root of number in Excel
When you are weak in math, even a cube root becomes a huge deal🙅! So, to find out the cube root🤓 of a number in excel, here’s what you can…
Continue readingConvert feet and inches to inches In Excel
If you are looking for a way where you could convert feet and inches into inches through excel, you have come up in the right place. You see, when you…
Continue readingHow to get the name from email address QUICKLY in excel?
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.
Continue readingGet number of hours between two times
If you have two timings⏳ in your screen and you want to calculate the difference between them or in other words you want to calculate the number of hours that…
Continue reading