Learn Microsoft Excel Online FreeThis post will guide you how to sum range of cells ignoring Errors in Excel. How do I sum and ignore errors with a formula in Excel. How to sum range ignoring all error values with VBA macro in Excel. Sum Range Ignoring Errors with Formula Sum Range Ignoring Errors with VBA Sum Range Ignoring… read more »
This post will guide you how to convert Julian date to a calendar date in Excel. How do I convert a given Julian Date to a calendar date with a formula in Excel. What is Julian Date? Julian day number is the integer assigned to a whole solar day in the Julian day count starting… read more »
This post will guide you how to find the maximum value in a range of cells based on single or multiple criteria in Excel. How do I calculate the Minimum value based on criteria with MIN Function in Excel. Find Max Value based on Single Criteria Find Max Value based on Multiple Criteria Find Min… read more »
This post will guide you how to remove all numbers from a text string in one cell in Excel. How do I strip all numeric characters from a given cell with a formula in Excel. How do I remove numbers from cells with text using a User Defined Function in Excel. Remove Numbers From Text… read more »
This post will guide you how to check if a cell value is between two numbers in Excel. How do I build an IF statement that test if a cell value is between two given values in formula in Excel. Check Value If It Is between Two Numbers Assuming that you have list of data… read more »
This post will guide you how to extract a unique distinct list from two or more columns in Excel. How do I get a list of distinct values in multiple columns with a formula in Excel. How to create a list of unique values from a range of cells using VBA Code in Excel. Extract… read more »
This post will guide you how to create dynamic interactive chart in Excel. How do I create an interactive chart using option buttons in Excel. Create Dynamic Interactive Charts Video:Create Dynamic Interactive Charts Create Dynamic Interactive Charts Assuming that you have a list of data in range A1:D4, and you want to create a dynamic… read more »
This post will guide you how to ignore blank cells in a formula in Excel. How do I ignore blank cells when performing calculations in a formula in Excel. Ignore Blank Cells in a Formula Video：Ignore Blank Cells in a Formula Ignore Blank Cells in a Formula If you have a formula to calculate a… read more »
This post will guide you how get the nth matching values with VLOOKUP function in Excel. How do I find the nth match value with Index/Match formula in Excel. How to find the first, second, third or nth matching value from a range of cells using VLOOKUP formula. Find the First Match Value Using VLOOKUP… 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 »
