Thread: Reverse Order of Data Set
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote