Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Rows in A Pattern
Hello -
I have a data set from a Pivot table, and I want to delete every row with a blank underneath Total. This turns out to be every 4th row. Is there a way to automatically delete every 4th row in excel? Any help is greatly appreciated. Product Period Data Total A Q1 Total Number of Items 1 Diff from Q1 Q2 Total Number of Items 4 Diff from Q1 3 B Q1 Total Number of Items 2 Diff from Q1 Q2 Total Number of Items 3 Diff from Q1 1 C Q1 Total Number of Items 3 Diff from Q1 Q2 Total Number of Items 2 Diff from Q1 -1 D Q1 Total Number of Items 4 Diff from Q1 Q2 Total Number of Items 1 Diff from Q1 -3 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Rows in A Pattern
I have a data set from a Pivot table, and I want to delete every row with a
blank underneath Total. If you mean a copy of pivot, not a real pivot .. Filter on that "Total" col, select blanks Select filtered rows, right click Delete row -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows in a Pattern | Excel Discussion (Misc queries) | |||
Deleting Rows In A Pattern | Excel Discussion (Misc queries) | |||
Removing (deleting, filtering) lines in a pattern . . . | Excel Discussion (Misc queries) | |||
repeat rows pattern through pages | Excel Discussion (Misc queries) | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) |