Sorry, I probably wasn't clear enough. I'm looking for a solution that will put those strings (on separate lines) in ONE cell with word wrap. Basically it needs to find each instance where a row has "inadequate" and print those three values on a new line in a single cell. It seems more like an array type of solution that I am unaware of.
On Jan 20, 2:36 am, ankur <[email protected]> wrote: > Hi Myke, > find the enclosed file > > On 20/01/2010, [email protected] <[email protected]> wrote: > > > > > > > Hi Myke, > > > This can done by the following formula. > > > =IF(C1="Inadequate",A1&" "&B1&" "&C1&CHAR(10),"") > > > Hope this is will help you. > > > Cheers, > > Valli > > > On Jan 20, 2:30 am, Myke <[email protected]> wrote: > >> Hello All, > > >> While this may sound silly, I'm trying to concatenate values in 3 > >> columns into a single cell to essentially create a list using a > >> formula. > > >> A B C > > >> 1 Area1 Value1 Inadequate > > >> 2 Area2 Value2 Adequate > > >> 3 Area3 Value3 Inadequate > > >> The manual way for me to do this is: > > >> Concatenate(A1, " ",B1," ",C1,Char(10)) > > >> As you can see I want space between each value and a new line at the > >> end. I want all rows where column C has "Inadequate" and for this > >> concatenation to happen in one cell. The reason for this is so that I > >> can refer to that cell using a text box in another sheet. > > >> I'm probably taking the wrong approach to accomplish this. Any help or > >> suggestions are greatly appreciated! > > >> Thank you, > >> Myke > > -- > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > Solution By Ankur2.xls > 30KViewDownload
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
