Manipulating Order Quantities with a Formula
 

I am looking at an order file with approximately 3000 orders. Column F is
the customer name, column J is the item #, and column P is the order quantity
(in pieces). I want to manipulate this data such that the file will show (in
a separate sheet) units per order by item # within a range of increments of 5
pieces: 0-5 pieces, 5-10 pieces, and so on.

I also want any potential negative numbers (negative number of pieces) not
to be in the range. (Maybe they can be grouped by themselves?)

Is that possible? Thanks for reading my question!

Manipulating Order Quantities with a Formula
 

I would suggest using a pivot table. Within the pivot, you can group
the data fields to display as you described below.

On Nov 7, 9:32*am, Liz J wrote:
I am looking at an order file with approximately 3000 orders. *Column F is
the customer name, column J is the item #, and column P is the order quantity
(in pieces). *I want to manipulate this data such that the file will show (in
a separate sheet) units per order by item # within a range of increments of 5
pieces: 0-5 pieces, 5-10 pieces, and so on.

I also want any potential negative numbers (negative number of pieces) not
to be in the range. (Maybe they can be grouped by themselves?)

Is that possible? *Thanks for reading my question!

Manipulating Order Quantities with a Formula
 

How specifically to manipulate the pivot table to give you the ranges of
orders: 0-5 pieces, 5-10 pieces, etc?

Thanks!

"Tim879" wrote:

I would suggest using a pivot table. Within the pivot, you can group
the data fields to display as you described below.

On Nov 7, 9:32 am, Liz J wrote:
I am looking at an order file with approximately 3000 orders. Column F is
the customer name, column J is the item #, and column P is the order quantity
(in pieces). I want to manipulate this data such that the file will show (in
a separate sheet) units per order by item # within a range of increments of 5
pieces: 0-5 pieces, 5-10 pieces, and so on.

I also want any potential negative numbers (negative number of pieces) not
to be in the range. (Maybe they can be grouped by themselves?)

Is that possible? Thanks for reading my question!