KNS,

In cell O3, use the formula

=IF(A2=A3,IF(O2<"",O2&", ","") &IF(N31,REPT(J3&",
",N3-1)&J3,J3),IF(N31,REPT(J3&", ",N3-1)&J3,IF(N3<"",J3,"")))

In cell P3, use the formula

=IF(A3=A4,"",O3)

Select O3:P3, and copy down to match your data table. The non-blank cells in
column O will contain the strings for each order.

If that doesn't do what you want, post a small table of your data, and what
result you would like.

HTH,
Bernie
MS Excel MVP


"KNS" wrote in message
...
I've already gotten a partial answer to my question, but my boss is
pushing
me to try and find a solution faster, Basically, I have a spreadsheet full
of
orders, with a separate line in excel for every item regardless of whether
the items are on the same order or not. I need to combine the items so
that
they print in a single cell each item in the order, and that item the
number
of times it appears, so something along the lines of
=IF(N30,REPT(J3,N3),IF(A3=A4,J4,"")) Where N3 is the quantity of a single
item, J3 is the item SKU, and column A is the order numbers, which when
the
same means a multi-SKU order. Is this possible? If it is, is there a way
to
have it compare orders numbers until it comes to one that is different,
because theoretically we could have 20 SKUs on a single order. IF this
isn't
clear please ask for clarification of the point that is confusin.