Forum Discussion
An UDF for Concatenate Function
Hello I was wondering whether it is possible to achieve this result using VBA/UDF? https://ibb.co/2yn729f Basically what I wanted to do is to be able to concatenate various string fr...
Thank you for you dedication to my problem.
Maybe I need to elaborate more clearly what I am trying to achieve. Here is a new image
https://ibb.co/44tSnkk
I have this fruit, qty and a when column. Then, I will share this excel file to other people, What I want to do is that they can get different result based on what cells or combination that they like.
How to do that? And also the data for each column are fixed but the result should be vary.
Maybe I need to elaborate more clearly what I am trying to achieve. Here is a new image
https://ibb.co/44tSnkk
I have this fruit, qty and a when column. Then, I will share this excel file to other people, What I want to do is that they can get different result based on what cells or combination that they like.
How to do that? And also the data for each column are fixed but the result should be vary.
No problems.
So it still sounds like the same solution as I mentioned in my first reply but it sounds like you want to add drop down lists where people can select which Fruit, Qty and When option - and then the result will be a combination of those 3?
If that's the case, you need to create Data Validation lists for those three and then link the result in the same way as in my first reply. Just Google how to create Data Validation lists in Excel.
If you're still stuck, let us know.
So it still sounds like the same solution as I mentioned in my first reply but it sounds like you want to add drop down lists where people can select which Fruit, Qty and When option - and then the result will be a combination of those 3?
If that's the case, you need to create Data Validation lists for those three and then link the result in the same way as in my first reply. Just Google how to create Data Validation lists in Excel.
If you're still stuck, let us know.