![]() |
Group & sort rows that have a specific value in column C
I have sorted rows according to the values in column C. How do I now sort
all rows that have a particular value in column C (now that they are grouped together) according to the value in column E. |
Group & sort rows that have a specific value in column C
Lex I hope I am understanding you correctly here, but it sounds to me like you want to Sort by column C and then by Column E (as the options in the Sort dialog) - does this do what you want, or have I misunderstood? Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=546199 |
Group & sort rows that have a specific value in column C
After I sort the rows by column C (5000, 3800, 3400, 3100, 3000, 2000 are the
possible values in column C and are now grouped together) I now want to sort each grouping and add the subtotals. I am currently having to block the information so that the range of rows covers just the 5000's in column C, then sort that group by the information in columns E and secondarily Column L. Then, block the next group of rows and sort them, then the next, etc. I want to design a macro to do this automatically, but the number of rows in each grouping vary. Any ideas "RichardSchollar" wrote: Lex I hope I am understanding you correctly here, but it sounds to me like you want to Sort by column C and then by Column E (as the options in the Sort dialog) - does this do what you want, or have I misunderstood? Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=546199 |
Group & sort rows that have a specific value in column C
Hello Lex,
I am an apprentice Excel user, but what I think you could use is /DATA/SubTotals. This will sort your columns and data according to the various criteria available. Hope it helps Thanks Max "Lex" wrote: After I sort the rows by column C (5000, 3800, 3400, 3100, 3000, 2000 are the possible values in column C and are now grouped together) I now want to sort each grouping and add the subtotals. I am currently having to block the information so that the range of rows covers just the 5000's in column C, then sort that group by the information in columns E and secondarily Column L. Then, block the next group of rows and sort them, then the next, etc. I want to design a macro to do this automatically, but the number of rows in each grouping vary. Any ideas "RichardSchollar" wrote: Lex I hope I am understanding you correctly here, but it sounds to me like you want to Sort by column C and then by Column E (as the options in the Sort dialog) - does this do what you want, or have I misunderstood? Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=546199 |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com