Similar Posts
EXCEL FUNCTION – AND, OR, NOT
AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”
EXCEL FUNCTION – LOWER
LOWER function is used for changing the format of any text or string to LOWER case.
Excel Function – SUBTOTAL
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
EXCEL FUNCTION – DAY, MONTH, YEAR
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.
VBA Code to Remove Duplicate Rows
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.