How to sort into a new table

  • Thread starter Thread starter CWatters
  • Start date Start date
C

CWatters

I'm familiar with the sort ascending button - but that "sorts in place" and
I need to preserve the original table (I don't want to have to manually copy
it each time the data changes either).

I was trying to use a formulae something (but not exactly) like this to copy
and sort rows into an second table...

{=INDEX(Array, MATCH(LARGE(Column,1),0)}
{=INDEX(Array, MATCH(LARGE(Column,2),0)}
{=INDEX(Array, MATCH(LARGE(Column,3),0)}
etc

.... but it doesn't handle duplicate matches in the sort column.

can someone point me to some good examples or suggest a better way?
 
Why not insert a new column in column A and fill in an
index number for each item. You can then sort the table as
you like and re-set it again using the index numbers.

Regards
Peter Atherton
(e-mail address removed)
 
Peter said:
Why not insert a new column in column A and fill in an
index number for each item. You can then sort the table as
you like and re-set it again using the index numbers.
Click to expand...

I really need both tables at the same time and eliminate the manual steps.
Thanks anyway.
 
Back
Top