Re: $$Excel-Macros$$ Conditional Concatenate
Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.comwrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5 ),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge
Re: $$Excel-Macros$$ Conditional Concatenate
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 rajanverma1...@gmail.comwrote: Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE( O2,,,O3,,,O4,,,O5),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en . -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
Re: $$Excel-Macros$$ Conditional Concatenate
Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar satendrakuma...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE( O2,,,O3,,,O4,,,O5),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use
Re: $$Excel-Macros$$ Conditional Concatenate
try the attachment see if it helps On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar satendrakuma...@gmail.comwrote: Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar satendrakuma...@gmail.com 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 rajanverma1...@gmail.comwrote: Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE( O2,,,O3,,,O4,,,O5),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en . -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards
Re: $$Excel-Macros$$ Conditional Concatenate
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 koul.ash...@gmail.com wrote: try the attachment see if it helps On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar satendrakuma...@gmail.com wrote: Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar satendrakuma...@gmail.com 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 rajanverma1...@gmail.comwrote: Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.com 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE( O2,,,O3,,,O4,,,O5),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from
Re: $$Excel-Macros$$ Conditional Concatenate
write UDF then On Fri, Jan 11, 2013 at 5:15 PM, Satendra kumar satendrakuma...@gmail.comwrote: 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 koul.ash...@gmail.comwrote: try the attachment see if it helps On Fri, Jan 11, 2013 at 3:50 PM, Satendra kumar satendrakuma...@gmail.com wrote: Hi All, any solution please thankx satendra On Fri, Jan 11, 2013 at 1:44 PM, Satendra kumar satendrakuma...@gmail.com 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 rajanverma1...@gmail.comwrote: Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.com 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE( O2,,,O3,,,O4,,,O5),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA
Re: $$Excel-Macros$$ Conditional Concatenate
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 satendrakuma...@gmail.comwrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5 ),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Conditional Concatenate
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, अनिल नारायण गवली gawlianil8...@gmail.comwrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5 ),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Conditional Concatenate
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.comwrote: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5 ),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Conditional Concatenate
Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: 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: 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, अनिल नारायण गवली gawlianil8...@gmail.com wrote: 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 satendrakuma...@gmail.com wrote: Dear Expert, Solve this query..i want automate colored range. if you have any solution please provide. Like Exce. =IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5 ),),) Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not