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))
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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks