Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I SHIFT ROWS BASED ON A GIVEN VALUE
I HAVE A 38 PAGE PRICE LIST WHERE COLUMN "A" IS A DESCRIPTION OF THE ITEM,
COLUMN "B" IS THE PRICE, COLUMN "C" IS THE QUANTITY AND COLUMN "D" IS THE TOTAL (B*C). HOW DO I SHIFT ALL ROWS TO THE TOP OF THE WORKSHEET WHERE COLUMN "C" IS 0 AND LEAVE THE OTHER ROWS ALONE? OR MOVE ALL ROWS WITH A COLUMN C VALUE 0 TO ANOTHER PAGE? |
#2
|
|||
|
|||
I'd apply data|filter|autofilter and show those rows with a value 0.
Then I could copy and paste to another sheet. Then come back and delete those rows. === I'm not quite sure what leave those other rows alone, but maybe selecting your range and sorting by column C would be sufficient. MIKE K wrote: I HAVE A 38 PAGE PRICE LIST WHERE COLUMN "A" IS A DESCRIPTION OF THE ITEM, COLUMN "B" IS THE PRICE, COLUMN "C" IS THE QUANTITY AND COLUMN "D" IS THE TOTAL (B*C). HOW DO I SHIFT ALL ROWS TO THE TOP OF THE WORKSHEET WHERE COLUMN "C" IS 0 AND LEAVE THE OTHER ROWS ALONE? OR MOVE ALL ROWS WITH A COLUMN C VALUE 0 TO ANOTHER PAGE? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
HOW DO I SHIFT ROWS BASED ON A GIVEN VALUE | Excel Discussion (Misc queries) | |||
Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
Grabbing recods based on date and shift values | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |