• 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. M

    How to do a formula like subtotal but with text

    Chandoo, I never use offset set so I wasn’t sure how they work. Sajan, that seems to how work! When you do the =INDEX(ConcatValues,MATCH(F2,NumbersList)) does it always grab the last value and return that. So in the above table when i =INDEX(ConcatValues,MATCH(F2,NumbersList))for the...
  2. M

    How to do a formula like subtotal but with text

    Yes, I saw that. I might have been unclear. But I have(table above)column A=numbers and column B=Data. I need to have a formula like, if any Number in the range of A1:A300 are the same then concat all B1:B300 into one cell. I want to do this for the whole worksheet vs manually concat myself...
  3. M

    How to do a formula like subtotal but with text

    Here’s my some data 9 rows out of 2,000. I need to combine all the data for "1" into one cell, so it looks like 1 apple, back, cat. So that I can in return vlookup "1" and get apple, back, cat. I think of it as "subtotal" for text. So a every change in number "sum/combine" data. The data can be...
Back
Top