Latest Lists

Is there a formula or command to reverse the order of a list in Excel?

We have one column of data, it is alpha numeric, with some items being only alpha so we cannot sort acsending or descending or it screws up the list. We want to make the last item (A13110) the first in the list, ending with the first item (A1) but keeping the data in the same order, just flipped. Is this even possible?

Public Comments

1. There is no formula per se, but there is a way to do it: - in an adjacent column (I'll assume B), fill the column with 1, 2, 3, etc., starting at B1=1 and ending at B13110=13110 - select the data in both columns A and B - Data - Sort - Sort by: Column B, Descending This will reverse the order. Add detail, or e-mail if you need more info. Good luck. .