How do I sort by ranges?
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? |
How do I sort by ranges?
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 .... Clevernewt wrote: 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? -- Dave Peterson |
How do I sort by ranges?
Thank you,
I'll try. "Dave Peterson" wrote: 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 .... Clevernewt wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com