Completed
) Power Query (Get & Transform). MIN and MAX functions can handle Alphanumeric/Text Values. See Group By feature and Add Custom Column Feature. (Excel 2010, 2013, 2016).
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
MIN & MAX Functions for Alphanumeric - Text Values Report
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction To Problem of finding MIN & MAX Alphanumeric/Text Values
- 2 ) VLOOKUP: 1) No Helper Column & 2) Columns Sorted (Any Version of Excel)
- 3 ) MIN/MAX & IF Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Any Version of Excel)
- 4 ) AGGREGATE Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2010 or later)
- 5 ) MINIFS/MAXIFS, INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2016 or later)
- 6 ) Excel Lookup Array Formula MIN/MAX & IF & MATCH Array Formula: 1) No Helper Column & 2) Columns Not Sorted (Any Version of Excel)
- 7 ) Access Query made in Design View, then Import into Excel. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version)
- 8 ) Power Query (Get & Transform). MIN and MAX functions can handle Alphanumeric/Text Values. See Group By feature and Add Custom Column Feature. (Excel 2010, 2013, 2016).
- 9 ) SQL in MS Query Data Import feature. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version)
- 10 ) Summary
