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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to regroup rows that have the same value in a particular colum
Select cols A to E, then do a Data Sort Sort by: Quantity (descending) OK
-- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "capxc" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Here is a clean version of the illustration.
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 DESC PRC WRH QTY A B C D E 1 01555 kshn 2.99 OH 6 2 05478 ookj 6.44 OH 0 3 25980 oidsi 5.99 TX 0 4 31512 psdi 8.54 NV 1 5 68462 oids 6.55 TX 0 6 85463 kjiis 9.44 OR 4 7 85456 oidjj 3.20 FL 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 -- capxc "capxc" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to regroup rows that have the same value in a particular c
Thank You Max.
Sincerely, -- capxc "Max" wrote: Select cols A to E, then do a Data Sort Sort by: Quantity (descending) OK -- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "capxc" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to regroup rows that have the same value in a particular c
Welcome. Pl press the "Yes" button below
-- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "capxc" wrote: Thank You Max. Sincerely, -- capxc |
Reply |
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) |