View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default listing a column in reverse order

copy column A to column B
in column C, enter:
1
2
3
4
5
6
....

down as far as column B

Then sort columns B & C by C descending
--
Gary''s Student - gsnu200760


"Archimedes" wrote:

Column A contains a finite list of numbers, not necessarily sorted by order
of magnitude. I want Column B to contain the same list of numbers, but
listed in precisely the reverse order. How do I do this?