Other Q&A Formulas

Reversing The Order Of Values In A List

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$7)-ROW()+1,0)) Example: List_____Opposite List___Formula Result 1________5_______________5 2________4_______________4 3________3_______________3 4________2_______________2 5________1_______________1 … Continue reading

Page 3 of 41234
Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube