Microsoft Excel - Sorting, Sub-totaling and again sorting sub-totaled data..

Asked By Fazal
24-Jan-11 09:08 AM
Hello everyone.  I'm new to Excel 2007.  I'm looking for solution.  I need to sort my data having 1000 Rows.. on A, and then sub-total it on the basis of Colum A. Now in level 3 (sub-total), i need to sort data between the sub-totals.

DAYS ID_RN SNO YEAR INDEX BLNO NAME CLASS
3 KAP 6979 2010 429 ANDDF654654 XYZ A
3 Count           1  
4 KAP 6987 2010 318 SFD5454545 XYZ A
4 KAP 6715 2010 267 DFDFD546546 XYZ A
4 KAP 7210 2010 341 DFDFD55555 XYZ B
4 KAP 7005 2010 101 DFDF55555 XYZ B
4 KAP 7449 2010 166 DFDSF55555 XYZ B
4 KAP 7449 2010 166 DSFDF6S54 XYZ A
4 KAP 6979 2010 430 TTPP XYZ A
4 KAP 6979 2010 430 TTPP ABC A
4 KAP 6956 2010 154 TTPPP ABC B
4 KAP 7054 2010 407 TPP ABC A
4 KAP 7016 2010 431 TTP ABC B
4 KAP 7054 2010 355 TTPPP ABC A
4 KAP 6979 2010 345 TTPPP ABC A
4 KAP 6979 2010 346 TTPPP ABC A
4 KAP 2131 2007 257 TTPP ABC A
4 KAP 2055 2007 214 HCTT ABC B
4 KAP 2038 2007 165 HCTT ABC B
4 KAP 4498 2008 99 HCTT ABC B
4 KAP   6269 2009 64 HCTT ABC A    

I've sorted data on Days, then sub-totaled it Each change in "DAYS" count "NAME" an then sort on CLASS.

I wud appreciate if somebody could help me... thanks     
  wally eye replied to Fazal
24-Jan-11 11:16 AM
Would a pivot table work for you?  It won't show you the data that makes up the subtotals, but it will allow for multiple levels of subtotals.
Create New Account
help
Enregistrer dbf sous excel 2007 Excel Bonjour la Communaut??, Comment r??ussir ?? enregistrer un format dbf sous excel 2007? Merci pour vos conseils Bernie Excel - French Discussions Microsoft Excel (1) Excel 2003 (1) Excel 2007 (1) DBASE (1) Enregistrer (1) Communaut (1) Conseils (1
What are the differences between excel 2000 & excel 2007? Excel We're trying to decide if it would be beneficial to upgrade from excel 2000 to excel 2007. What are the differences between excel 2000 & excel 2007? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2007 (1) BA597438D5D2 (1) Previews
Conflict with Valid Range Reference Error in Microsoft Excel 2007 Excel Hi, While converting the Macros enabled Microsoft Excel 2003 to Microsoft Excel 2007 format, I am getting the following Conflict with Valid Range Reference Error. After clicking
Deleating All Selected Data Excel 2007 Excel Excel 2007 (What worked for Excel 2003 makes 2007 crash). I have run Microsoft Office Diagnostics and it can not identify any problems) When I try to delete data
SQL plus de Inclure les noms de champ dans SQL EXcel 2007 Excel Bonjour, Nous venons de miger de Microsoft Excel 2003 vers Microsoft Excel 2007. Dans la version Excel 2003, on avait avec clic droit sur une plage de donnÃ