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!