How to select every alternate row in excel Many times we have required to select every alternate row for highlight or delete it. even sometimes we download data from where row after…
Tag: Excel Formula
How To Use IFNA function in excel
How To Use IFNA function in excel The IFNA function in Excel is a logical function that allows you to handle the #N/A error that occurs when a value is not found…
How to Use False Function in Excel
How to Use False Function in Excel The FALSE function in Excel is a logical function that simply returns the logical value of FALSE. This function can be used in various scenarios…
How to Solve #DIV/0! Error in Excel?
How To Solve Error #DIV/0! in Excel? If you have been working in Mircosoft Excel then I am sure you have many face error #DIV/0! error. In this tutorial, I will show…
How to Compare Dates in Excel
How to Compare Dates in Excel Many times we are facing issues in working with Dates in Microsoft excel. When we see dates in excel we think those are the same. There…
How to Get Day Name from Date in Excel
Sometimes while we are working with Dates in Excel you want to know the day on that date is Tuesday or Friday. This could be mainly required when we are planning for…
How to Add Months to Date in Excel
Have you ever been required to find a specific date after some months like after 6 months or 12 months? Excel has one inbuilt function EDATE which will help to do exactly…
How to Sum alternative Rows or Column
From this article, you will learn how to sum alternative rows/ columns in Excel with help of SUMIF Function. Excel has various functions, including functions to calculate the inverse cosine of a…
How to use LEFT Function in Excel
When to Use Left Function ? When you want to Extract Specific Number of Character from Cell or String from the First Character of Left Side. How to Use Left Function ?…
How to use Rept Function in Excel
How to use Rept Function in Excel? Rept Function is used in excel to return a text or value repeatedly specified number of times. Some times we need to repeat some text…