ExcelHow

Category: Excel Examples

Check if Cell Contains Certain Values but do not Contain Others Values

Excel Examples

December 24, 2017
How to get last match that cell contains one of several values in a range

Excel Examples

December 24, 2017
How to get first match that cell contains one of several values in a range

Excel Examples

December 23, 2017
How to Extract Text between Commas

Excel Examples

December 23, 2017
How to Extract Text between Parentheses

Excel Examples

December 22, 2017
How to check if Cell contains one of many values from range

Excel Examples

December 21, 2017
How to Check If Cell Contains All Values from Range

Excel Examples

December 21, 2017
How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

Excel Examples

December 20, 2017
How to Extract Attribute Values from XML/HTML Data

Excel Examples

December 17, 2017
How to Extract a List of Unique Values from a Column Range

Excel Examples

December 16, 2017
How to Get the First Match in Two Excel Ranges

Excel Examples

December 15, 2017
How to Get Cell Address of a Lookup Value

Excel Examples

December 15, 2017
Two-way Lookup Formula

Excel Examples

December 14, 2017
How to SUM a Column with Lookup value in a Range

Excel Examples

December 14, 2017
How to Extract the Entire Column of a Matched Value

Excel Examples

December 13, 2017
How to Lookup Entire Row using INDEX/MATCH

Excel Examples

December 13, 2017
How to find the nth Largest Value

Excel Examples

December 12, 2017
How to Find the nth Smallest Value

Excel Examples

December 11, 2017
How to Lookup the Value with Multiple Criteria

Excel Examples

December 8, 2017
How to Reverse a List or Range

Excel Examples

December 6, 2017