• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Combine text from multiple columns based on condition

    Hello Friends, Thanks for your inputs. Looks like creating a function will be a neater solution. Can someone help me write such a function with two arguments 1. Array and 2. delimitter character. The output should come in a row with one string occupying one column and so on. Thanks in advance.
  2. A

    Combine text from multiple columns based on condition

    Hi Faseeh and NarayanK, Both your proposed solutions are known to me as well... which is by simply use of concatenate function or use of & sign. However my actual sheet is huge with numerous rows and thus its not possible for me to write a huge concatenate formula. I am looking for another...
  3. A

    Combine text from multiple columns based on condition

    Hello, I have data in spread across multiple rows and columns. Column A is list of some email IDs and column B to Z are list of Interests (e.g. Games, Cooking, Philately, etc.) The input of interest is taken on a 10 point scale wherein no value represents that the email ID is not interested in...
Back
Top