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

data from coloumn crieteria to in a cell.

Dear Friends,

Need your valuable assistance.

somebody can please help me in attached query.

Thanks in advance.

MK
 

Attachments

  • example file.xlsx
    8.4 KB · Views: 3
Thanks for your quick reply bosco...
really appreciable..

unfortunately I am getting below error;
did I missed anything...!

82915
 
Thanks for your quick reply bosco...
really appreciable..

unfortunately I am getting below error;
did I missed anything...!

View attachment 82915
Maybe you don't have Textjoin function in your Excel.

Textjoin function only available in Excel 2019, Excel 2021 and O365.

And, if you still wanted to use formula, please download a Textjoin UDF by Google searching machine.

Note: Without Textjoin function, it will become a lo.......ng formula.

So that, you better open a new post and forwards your question to our VBA forum.

Thank you.
 
Last edited:
Thanks you so much bosco....

due to office restrictions not be able to download that function...

would be more thanksful if you make small VBA...

thanksful for your every valuable seconds... :)
 
Back
Top