excel IFERROR

How to Get the List of File Names From a Folder

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 »

How to Extract a List of Unique Values from a Column Range

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 »

How to remove non numeric characters from a cell

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 »

Excel IFError Function

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 »

Sidebar