Thread: Formula needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Formula needed

not positive what you want, but maybe
=if(c30,c$1,"")&if(e$30,", "&e1,"")&...

or if you mean
=if(min(C3:C100)0,C$1,"")&if(Min(E3:E100)0,", "&E$1,"")&...

"William@Target" wrote:

I want create a formula that if the Min column (C3, F3, I3, and so on...) is
greater than 0, then A1 will combine the XX1, XX2, XX3 and so on... can
anyone help????

For clarification... then A1 will combine to show "XX1, XX2, XX3" and so
on... can
anyone help????


FAC, MIN and MAX are their own column

Columns: A B C D E
F G
Row 1 XX1 XX2
Row 2 FAC MIN MAX FAC MIN MAX
Row 3 1 1 1 1 1
1