Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals including blank rows
Greetings, I use the subtotals feature frequently...recently something weird
has happened. When I use the subtotals feature it inserts a blank row after the last group. I have determined that the empty row is a direct result of a previous row that has been removed. Here is an example... I have a spreadsheet that has 50 rows and 10 columns... 1.) I do a subtotal for the 1st column and it has 5 groups...(subtotal works fine) 2.) I remove the subtotal 3.) I sort by the 2nd Column 4.) I subtotal column 2 and the subtotal selects a total of 56 rows (one blank row for each previous subtotaled group and one for the grand total row) This event occurs each time I remove or delete a row. 2nd subtotal had 6 groups...after I remove that subtotal and do teh next subtotal it has 63 rows of which 13 are now empty. I hope you see the pattern. The end result of this is that the subtotals appear to get me correct data, the problem occurs when I want to sort the data. It won't sort properly. I was hoping that someone may have seen this previously and have a fix for me. VERY Annoying with the amount of data I am working with. Thanks in advance for looking. I am also using Excel 2002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
Sort Macro to Exclude Blank Rows? | Excel Worksheet Functions | |||
combine speadsheets leaving no blank rows on master page | Excel Discussion (Misc queries) | |||
Blank Rows | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |