Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




Reverse Order of Data Set
How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12, A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I make this happen for a large set of data? 
#2




Answer: Reverse Order of Data Set
There is a quick and easy way to reverse the order of a large set of data in Excel without having to retype each cell. Here are the steps:
This will reverse the order of the selected cells without having to retype each cell.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.worksheet.functions




Reverse Order of Data Set
Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B
using Column B, sort descending. "Bekah1st" wrote: How do you reverse the order of a large set of data without having to retype each cell? For example if I had data in the following order: A1: 10, A2: 12, A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I make this happen for a large set of data? 
#4
Posted to microsoft.public.excel.worksheet.functions




Reverse Order of Data Set
so clever! thank you! it worked like a dream!
"JMB" wrote: Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B using Column B, sort descending. "Bekah1st" wrote: How do you reverse the order of a large set of data without having to retype each cell? For example if I had data in the following order: A1: 10, A2: 12, A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I make this happen for a large set of data? 
#5
Posted to microsoft.public.excel.worksheet.functions




Reverse Order of Data Set
DataSortDescending
Gord Dibben MS Excel MVP On Mon, 30 Apr 2007 15:58:03 0700, Bekah1st wrote: How do you reverse the order of a large set of data without having to retype each cell? For example if I had data in the following order: A1: 10, A2: 12, A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I make this happen for a large set of data? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do I reverse name order from Last, First to First Last in Exc  Excel Discussion (Misc queries)  
Can I reverse the order of data in a set of cells?  Excel Discussion (Misc queries)  
How to reverse the order of data in a single column in Excell?  Excel Discussion (Misc queries)  
How do I reverse the order (sequence) of a column of data in Excel  Excel Worksheet Functions  
How do I quickly reverse the order of a set of data  Excel Discussion (Misc queries) 