How do I sort by ranges?

  • Thread starter Thread starter Clevernewt
  • Start date Start date
C

Clevernewt

I have s spreadsheet where the data are in ranges,
with some cells empty,
and I need to sort the data by a velue in one of the columns,
but to keep the ranges as they are.
What should I do?
 
Maybe you can put a key value (in another column) in each set of rows that
should be sorted together. Then you could sort by that key value.

You may need a second column so that the rows should be sorted together stay in
the correct order.

KeyA 1
KeyA 2
KeyA 3
KeyB 1
KeyB 2
....
 
Thank you,
I'll try.

Dave Peterson said:
Maybe you can put a key value (in another column) in each set of rows that
should be sorted together. Then you could sort by that key value.

You may need a second column so that the rows should be sorted together stay in
the correct order.

KeyA 1
KeyA 2
KeyA 3
KeyB 1
KeyB 2
....
Click to expand...
 
Back
Top