Learn Microsoft Excel Online FreeThis post will guide you how to round a range of cells with a formula in Excel. How do I round a range of cells using VBA macro in Excel 2013/2016. How to round up a range of numbers in a column in Excel. Round a Range of Cells with ROUND Function Round a Range… read more »
This post will guide you how to sort dates or birthdays by month or day only in Excel. How do I sort dates by Year or Month or Day only with a formula in Excel 2013/2016. How to use the MONTH function and DAY function to sort dates by month or day only in Excel…. read more »
This post will guide you how to vlookup and return blank instead of 0 or #N/A error in Excel. How do I vlookup returning blank instead of 0 or #N/A when no data matched in Excel. Vlookup to Return Blank Instead of 0 or #N/A When you use vlookup function to search a value, and… read more »
This post will guide you how to add the current month or year into a cell or header or footer in your worksheet. How do I insert the current date or time in a cell with a formula in Excel. Add Current Month or Year Using Short Keys Add Current Month or Year Using Formula… read more »
This post will guide you how to do a VLOOKUP between two dates and return corresponding value in Excel. How do I VLOOKUP between two dates and return corresponding value with lookup formula in Excel. How to lookup a value if the date fall between two dates in Excel. VLOOKUP Value If Date Falls between… read more »
This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two or three columns with Conditional Formatting feature in Excel. Find Duplicate Rows Only Find and… read more »
This post will guide you how to convert column letter to number in Excel. How do I convert letter to number with a formula in Excel. How to convert column letter to number with VBA macro in Excel. How to use a User Defined Function to convert letter to number in Excel. Convert Column Letter… read more »
This post will guide you how to remove duplicates and replace with blank cells in Excel 2013/2016. How do I replace the duplicates with blank cells using a formula in Excel. Replace Duplicates with Blank Cells Show Only Duplicates Values Show Only Unique Values Video: Replace Duplicates with Blank Cells Replace Duplicates with Blank Cells… read more »
This post will guide you how to display negative time value in Excel. How do I change the way negative times are displayed in Excel. How to show negative dates or times with a formula in Excel. Display Negative Time Value Display Negative Time Value with Formula Video: Display Negative Time Value If the cell… read more »
This post will guide you how to return a value if a cell contains a certain number or text string in Excel. How do I check if a Cell contains specific text and then return another specific text in another cell with a formula in Excel. Return Value If Cell Contains Certain Value Video: Return… read more »
