MIN & MAX Functions for Alphanumeric - Text Values Report

MIN & MAX Functions for Alphanumeric - Text Values Report

ExcelIsFun via YouTube Direct link

) Summary

10 of 10

10 of 10

) Summary

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.