ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Column Values Re-Order Bottom to Top (https://www.excelbanter.com/excel-worksheet-functions/70734-column-values-re-order-bottom-top.html)

Jerry Pio

Column Values Re-Order Bottom to Top
 

If I import a long series of values in a column, how can I reverse the
order of values from top to bottom into bottom to top?


--
Jerry Pio
------------------------------------------------------------------------
Jerry Pio's Profile: http://www.excelforum.com/member.php...o&userid=31384
View this thread: http://www.excelforum.com/showthread...hreadid=510778


Buffgirl71

Column Values Re-Order Bottom to Top
 
Data / Sort - Check the Descending button (Ascending is the default,
but you can change it).


Jerry Pio

Column Values Re-Order Bottom to Top
 

Thanks for the reply.

I do not want to sort the data. I need the entries in exact order.
I just want to re-order the data and keep the list the same, only from
bottom to top. I have other ways to get this done but I was hoping
there was a short cut.


--
Jerry Pio
------------------------------------------------------------------------
Jerry Pio's Profile: http://www.excelforum.com/member.php...o&userid=31384
View this thread: http://www.excelforum.com/showthread...hreadid=510778



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com