Re: How do I quickly reverse the order of a set of data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Insert a temporary column, and number each row. Enter a 1 for the last
row, and in the row above that add 1; repeat so the first row is the
highest number. Then highlight all the rows, and sort on your
temporary column from lowest to highest. When you're done, delete the
temporary column.

.



Relevant Pages

  • Re: how does excel decide a suggested name to a range?
    ... duplicate reference in the first row. ... I can only repeat, what a great ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • RE: How to insert rows based on change in data
    ... I am assuming that the items which repeat are in column A. ... Add a temporary column and enter a formula like the following in C2 the ... Press Ctr+ or Ctrl Shift+ ... able to selcet the column and insert a row between where the data changes. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Select Max(col name) Expr1000
    ... >my own temporary column to return the max value into but I could not get ... Brian Bushay (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Select Max(col name) Expr1000
    ... my own temporary column to return the max value into but I could not get ... Exit; ... Prev by Date: ...
    (borland.public.delphi.database.ado)