View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bekah1st Bekah1st is offline
external usenet poster
 
Posts: 3
Default 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?