Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
Learn to use the Dynamic Array Functions SORT and SORTBY to sort and rank a list based on criteria from a corresponding range. This is especially useful for displaying a list that's ranked in order of performance or chronological order (date, time).

This is Part 4 of 6 in a series that shows you how to build a dashboard for an attendance report. This dashboard was originally submitted as an entry in the Excel Hash competition: https://youtu.be/FmHBpkscsZA

If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/functions/sort-sortby-functions/

Additional Resources:

Part 1 of 6: How to use the XOR Function: https://youtu.be/oe8oOmVRKOg
Part 2 of 6: How to use XLOOKUP for Reverse Order Search: https://youtu.be/5DAofCNCMb8
Part 3 of 6: Return Multiple Values for a Lookup Formula in Excel with FILTER and UNIQUE: https://youtu.be/ftDXUOKCaUM

Excel Hash: Attendance Report with Storm Clouds & Fireworks: https://www.youtube.com/watch?v=FmHBpkscsZA&t=30s

Dynamic Array Functions & Formulas that Spill https://www.youtube.com/watch?v=1HF0UGMF070

#MsExcel #ExcelCampus
00:00 Introduction
00:50 Sort and Rank
01:24 The SUMIF Function
04:15 The SORTBY Function
06:22 The SORT Function