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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
VBA set thick borders around non empty cells in range 0
sorting 4
VBA sort range with certain fontcolor 5
Problem sorting a range of columns using VBA 1
Macro to sort variable data range fails 1
Is not sorting 4
How to sort entire spreadsheet by one column sort 5

Back
Top