How to Reverse list of values in Excel

Tutorial demonstrating method of reversing list of selected values in range (which do not have alphabetical / numerical sorting) using pure Excel formula. Functions like LAMBDA / SORTBY / SEQUENCE / COUNTA are used to derive the formula. Method used Custom Funtion feature of Excel available using Name Manager, which can convert formula into custom function. A new function named REVERSE_COL is created for demo purpose. This technique does not use VBA Macros, but pure Excel formula to achive this.

Below is the formula to copy / paste:
=LAMBDA(rng,SORTBY(rng,SEQUENCE(COUNTA(rng)),-1))

0:00 Intro
0:23 Trailer / Featured Solution
0:41 Implementation
0:46 Step 1 - Generating serial numbers (SEQUENCE / COUNTA)
1:36 Step 2 - SORTBY function to reverse values
2:54 Step 3 - Converting to LAMBDA expression & Custom Function
6:25 Conclusion