Learn Microsoft Excel Online FreeThis post will guide you how to concatenate text values based on unique values in another column in Excel. How do I concatenate cells based on specific criteria in Excel. Concatenate Text Based on unique Values in Another Column Assuming that you have a list of data in range A1:B6, in which contain product IDs… 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 VLookup and return zero instead of #N/A in Excel. How do I use VLookup function and return zero instead of #N/A if not found in Excel. How to display zero instead of #N/A when using VLOOKUP in Excel. How to replace #N/A with Zero when VLOOKUP. VLOOKUP Returns… read more »
This post will guide you how to use the VLOOKUP function to find the values from multiple worksheets in Excel. For example, assuming that you have two worksheets, and you want to search the data across those two worksheet in your current worksheet (sheet3). How to do it. How to use the VLOOKUP function to… read more »
This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get the list of file names with different ways, such as: Excel VBA Macro, or FILES… read more »
This post explains that how to get the unique values from a range or column in excel. How to extract unique values from a list or excel range in excel 2013. Extract unique values If you want to extract a list of unique items from a column or range, you can use a combination of… read more »
This post explains that how to extract multiple match values from a range, then put the values into the different columns in excel. And how to extract multiple matches into the different rows. In the previous post, we talked that how to get the position of the nth occurrence of a value in a column,… read more »
This post explains that how to remove non-numeric characters (numbers) from a text string in one cell in excel 2016. How to remove non numeric characters from a cell containing text string with an excel formula. And how to remove alphanumeric characters from a cell with a user defined function in excel VBA. Remove non… read more »
This post will guide you how to use Excel IFERROR function with syntax and examples in Microsoft excel. Description The Excel IFERROR function returns an alternate value you specify if a formula results in an error, or returns the result of the formula. The IFERRORÂ function is a build-in function in Microsoft Excel and it is… read more »
