Sorting asceding and desceding

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all
i have a table which split the data to 3 sub parts
and i would like to sort the data of the first part by
deseding order the second part by asceding order and the
third part by desceding
the problem is that if i make any change on the first part
i will take the correct order but when i am trying to sort
the second part the i lose the order from the first part
another problem is that i manage to have the order bu
third column but i am not matching the order of the first
column

any help please?

Thanks in advance Manos
 
Hi Manos

if i understood you correctly you have 3 columns which stores your data
and now you want to sort column A descending and column B ascending.
For this use 'Data - Sort' and choos up to three sorting criteria

Frank
 
No i have 5 columns but quite a lot of rows
the parts are devides by rows
i want to sort the first part from 7c to 20c desceding

25b to 33b asceding

and from row 40c till 52c
if i sort the third part there is also problem with the
rows 7a to 20a, they are changing

there is anyway to make this sorting automated each time i
am changing the nmumbers?
 
Hi Manos

if you have blank rows between your parts this works fine for me. In
addition i woul add a blank row and a repeated header row. But with
that nor problem to sort the parts individually.

HTH, if not maybe you can mail me an example of your sheet and i'll
have a look at it

Frank
 
Back
Top