MIN & MAX Functions for Alphanumeric - Text Values Report

Overview

Learn eight different methods to create a report finding the MIN and MAX alphanumeric academic quarters for each student ID in Excel. Explore techniques including VLOOKUP, MIN & IF array formulas, AGGREGATE function, MINIFS function, non-helper column array formulas, Access Query, Power Query, and SQL. Download provided Excel files to follow along with practical examples suitable for various Excel versions, from basic to advanced data manipulation techniques.

Syllabus

) Introduction To Problem of finding MIN & MAX Alphanumeric/Text Values.
) VLOOKUP: 1) No Helper Column & 2) Columns Sorted (Any Version of Excel).
) MIN/MAX & IF Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Any Version of Excel).
) AGGREGATE Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2010 or later).
) MINIFS/MAXIFS, INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2016 or later).
) Excel Lookup Array Formula MIN/MAX & IF & MATCH Array Formula: 1) No Helper Column & 2) Columns Not Sorted (Any Version of Excel).
) Access Query made in Design View, then Import into Excel. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version).
) 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)..
) SQL in MS Query Data Import feature. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version).
) Summary.