Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread ashish koul
write UDF then On Fri, Jan 11, 2013 at 5:15 PM, Satendra kumar wrote: > many many thanks sir, > > but any other way with out helping column. > > > thankx > satendra > > > On Fri, Jan 11, 2013 at 5:06 PM, ashish koul wrote: > >> try the attachment see if it helps >> >> >> On Fri, Jan 11, 2013 at

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread Satendra kumar
many many thanks sir, but any other way with out helping column. thankx satendra On Fri, Jan 11, 2013 at 5:06 PM, ashish koul wrote: > try the attachment see if it helps > > > On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar > wrote: > >> Hi All, >> >> any solution please >> >> thank

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread ashish koul
try the attachment see if it helps On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar wrote: > Hi All, > > any solution please > > thankx > satendra > > > On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar > wrote: > >> Hi Dear, >> >> I'm not understand with this solution & not fulfill my req

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread Satendra kumar
Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar wrote: > Hi Dear, > > I'm not understand with this solution & not fulfill my requirement, > > please solve ! > > thankx > satendra > > > > On Fri, Jan 11, 2013 at 1:33 PM, rajan verma wrote: > >

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread Satendra kumar
Hi Dear, I'm not understand with this solution & not fulfill my requirement, please solve ! thankx satendra On Fri, Jan 11, 2013 at 1:33 PM, rajan verma wrote: > Hi > Please find attachement > > Rajan > > On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar < > satendrakuma...@gmail.com> wrote:

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread rajan verma
Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar wrote: > Dear Rajan ji, > > Please find attachment & solve , > > thankx > satendra > > > On Fri, Jan 11, 2013 at 1:13 PM, rajan verma wrote: > >> can be done with using concatenate function >> =A1&","&B1&","&C1&","

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread Satendra kumar
Dear Rajan ji, Please find attachment & solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma wrote: > can be done with using concatenate function > =A1&","&B1&","&C1&","&D1 > > Rajan > > On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar < > satendrakuma...@gmail.com> wrote: > >>

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread rajan verma
can be done with using concatenate function =A1&","&B1&","&C1&","&D1 Rajan On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar wrote: > Dear Anil, > > i have large database so how to define colored range?? > > > > =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,",",O3,",",O4,",",O5 > ),""),"") >

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread Satendra kumar
Dear Anil, i have large database so how to define colored range?? =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,",",O3,",",O4,",",O5 ),""),"") On Fri, Jan 11, 2013 at 11:50 AM, अनिल नारायण गवली wrote: > Dear Satendrakumar, > > use this =CONCATENATE(A1&","&B1&","&C1&","&D1) > if u want

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread अनिल नारायण गवली
Dear Satendrakumar, use this =CONCATENATE(A1&","&B1&","&C1&","&D1) if u want "," in between. or else share the workbook wit us. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar wrote: > Dear Expert, > > Solve this query..i want automate colored range. if you have a