» Reversing the Order of Values in a List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem:We want to rearrange the contents of the list in column A in reverse order.
Solution:
Use the OFFSET, COUNTA, and ROW functions as shown in the following formula:
=OFFSET($A$2,COUNTA($A$2:$A$6)-ROW()+1,0))
Book Store:
No comments have been submitted.
