YoVDO

MIN & MAX Functions for Alphanumeric - Text Values Report

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses SQL Courses VLOOKUP Courses Power Query Courses Aggregate Functions Courses Array Formulas Courses

Course Description

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.


Taught by

ExcelIsFun

Related Courses

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX