Learn Microsoft Excel Online FreeThis post will guide you how to check if one value in a column exists in another column in Excel. How do I check if value in column A exists in Column B with a formula in Excel. How to determine if values exists in another column in Excel. Check If Value in a Column… read more »
This post will guide you how to find missing numbers in a sequence with a formula in Excel. How do I identify missing numbers in a consecutive series in Excel. How to find missing serial number in Excel 2013/2016. Find Missing Numbers in a Sequence in Excel Assuming that you have a serial number list… read more »
This post will guide you how to generate all possible combinations with a formula in excel. How do I create list with all possible combinations of two lists in Excel. How to list all combinations from two separate list or range in Excel. Generate All Possible Combinations of Two Lists in Excel Assuming that you… read more »
This post will guide you how to count dates in a give year or month or day with a formula in Excel. How do I count cells based on year, month or day in Excel. How to countif by a specified date (Year or month) in a range of cells in Excel. Count Dates in… read more »
This post will guide you how to change negative number to zero in a cell in Excel. How do I make negative numbers to zero with a formula in Excel. How to remove all negative numbers from a range of cells and then changed them to zero value in Excel. Changing Negative Number to Zero… read more »
This post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… read more »
This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… read more »
This post will guide you how to vlookup a value and then return multiple corresponding values horizontally in Excel. How do I lookup a value and return multiple matched values in the same row in Excel. Or how to return multiple values with VLOOKUP function in Excel. VLOOKUP Return Multiple Values Horizontally Assuming that you… read more »
This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup From Another Workbook Before we use the VLOOKUP function to look for a value in… read more »
This post will guide you how to vlookup values in a range of cells and then return True or False values in Excel. How to use the VLOOKUP function to vlookup a value in a list of data, and return True or False values in a selected cells. In Excel, you can use the VLOOKUP… read more »
