Channel: MrExcel.com

Category: Howto & Style

Tags: excel tutorialsortby in excel to reverse a columnexcel custom list to sort a columnmrexcelhow to reverse a column in exceldueling excelmike girvinlambda function in excel to sort a columnmicrosoft excelbill jelenhow to flip a column in excelexcellambda in excel to flip a columnpower query in excel to flip a column

Description: You have a column of data in Excel. You need to reverse the column, bottom to top. How can you do this? Can you do it without a helper column? Bill Jelen and Mike Girvin compare six ways Table of Contents (0:00) Description of problem (0:49) Bill: SORTBY and SEQUENCE (2:15) Mike: INDEX and Converging range (3:23) Mike: INDEX and SEQUENCE (5:22) Bill: Custom List (6:43) Mike: LAMBDA (8:49) Bill: Power Query