=SUBSTITUTE(TRIM(IF(B225,"1 ","")&IF(C225,"2 ","")&IF(D225,"3
","")&IF(E225,4,""))," ",",")


"Tami" wrote:

I need a forumula to do the last column: tell me what weeks the units are
arrivng (e.g. 1,2,4) but the catch is that the units need to be greater thatn
25 in any given week (i don't want the formula to state the week # if its an
immaterial week.

wk1 wk2 wk3 wk4 weeks
Style1 200 300 0 100 1,2,4
Style2 0 0 100 0 3
Style 3 0 200 0 150 2,4