sorting table

[sobik]

hello again

i have a sheet that looks something like this:

number --- version --- date
     1 ---       1 --- 23.2.2005
     1 ---       2 --- 23.2.2005
     2 ---       1 --- 17.1.2005
     2 ---       2 --- 18.3.2005
     2 ---       3 --- 19.3.2005
     3 ---       1 --- 24.3.2005

an so on. i need to have it sorted by the date of the version 1. i don't care about the numbers in the first column, but all versions of one document must stay together.

any ideas?

thanks a lot!

 

[Thomas]

Unless I'm missing something here....

Does:

Data>Sort --> Sort by Version, then by Date

answer what you need here? If not, please post back and be a little more descriptive. :wink:

 

[sobik]

okay. i need it to look like this:

number --- version --- date 
     2 ---       1 --- 17.1.2005 
     2 ---       2 --- 18.3.2005 
     2 ---       3 --- 19.3.2005 
     1 ---       1 --- 23.2.2005 
     1 ---       2 --- 23.2.2005 
     3 ---       1 --- 24.3.2005

i need all versions (1, 2, 3...) of one document (the same number) stick together

is it more descriptive?

thanks a lot

 

[Etrnal168]

Bump, I need help with this too.

I have data in many columns, and one column contains the date. I want all the rows to be sorted based on the date, but all other columns must stick with the date.

How do I do this?

Thanks,

Thomas