ExcelHow

Tag: excel INDEX

Approximate Match with Multiple Criteria by INDEX & MATCH

Excel Examples

June 13, 2021
How to Find the Earliest and Latest Date in Excel

Excel Examples

June 20, 2020
How to Stack Data from Multiple Columns into One Column in Excel

Excel Examples, Excel VBA

March 29, 2020
How to Convert Horizontal List of Data into Vertical in Excel

Excel Examples

June 23, 2019
How to Lookup Values from Right to Left in Excel

Excel Examples

April 15, 2019
How to Create Dynamic Named Range in Excel

Excel Examples

March 22, 2019
How to Get Cell Address of Max or Min Value in a Range in Excel

Excel Examples

January 11, 2019
How to Extract a Unique Distinct List from a Column in Excel

Excel Examples

January 10, 2019
Find Closest Value or Nearest Value in a Range in Excel

Excel Examples

September 14, 2018
Split Data in One Column to Multiple Columns

Excel Examples

August 30, 2018
Finding the Max and Min value in an Alphanumeric Data

Excel Examples

July 11, 2018
How to Find the Maximal or Minimal String Based on Alphabetic Order

Excel Examples

May 23, 2018
How to get first match that cell contains one of several values in a range

Excel Examples

December 23, 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