MIN & MAX Functions for Alphanumeric - Text Values Report
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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.
Taught by
ExcelIsFun
Related Courses
Mastering SQL JoinsCoursera Project Network via Coursera Intermediate SQL Queries
DataCamp Introduction to SQL Server
DataCamp PostgreSQL Summary Stats and Window Functions
DataCamp Functions for Manipulating Data in SQL Server
DataCamp