Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to regroup rows that have the same value in a particular colum
We received our inventory report in a table of 5 columns by 2400 rows.
Some of our skus have 0 in quantity. And those skus with 0 quantity are here and there in the column E. How do we manage to regroup the report so that i have all rows that have 0 in qtty in the bottom ; and the other ones on the top? Here is an illustration: SKU ITEM DESCRIPTION PRICE WAREHOUSE QUANTITY A B C D E 1 01555 kshnhsdidsiidkdjdjj 2.99 ohio 6 2 05478 ookjjjccjcmcxmxm 6.44 ohio 0 3 25980 oidsidsjcjcjkcjcjckg 5.99 texas 0 4 31512 psdidsjjcjkjcjcjccm 8.54 nevada 1 5 68462 oidsjjfjjskssllslslsls 6.55 texas 0 6 85463 kjiissdsisjjjckkkijkhj 9.44 oregon 4 7 85456 oidjjsllsslslpokkjkkk 3.20 florida 0 How do we manage regroup rows 1,4 & 6 together; and rows 2,3,5 &7 together? The purpose is that we don't want to go through all the 2400 rows and manually select all the skus that have zero(0) in quantity because we have a lot of them. Thanks for sharing any tought. Sincerely, -- capxc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display data from rows to colum | Excel Discussion (Misc queries) | |||
Keep certain cells visible when scrolling, not just rows or colum | Excel Worksheet Functions | |||
Comparing two cells in a colum with 2000 rows | Excel Discussion (Misc queries) | |||
Print Colum/Rows | Excel Discussion (Misc queries) | |||
How do I make bi-Lingual on a colum in many rows? | Excel Discussion (Misc queries) |