Forum

Hello, I am just a basic user of VBA, but I will try to give some help anyway. What first strikes me is that your range where you copy the data fr...

Hello, I found this tip from a search engine. Br, Anders

Hello Gordon, As I see it, if you want to use the current layout of your data table/range then you need to create a "helper table/range" where you ...

Hi Harold, I will be stuck with playing around with this later this evening. Thanks for the tip. /Anders

Hello Estella, First things first, the way the current formula is built we need to have the same amount of rows as the lookup range has, so by exte...

Hello Estella, I changed your formula in cell Sheet1!B2 a bit, locked either the column or row reference and then copied it over the remaining cell...

Hi, It would be much easier for us to give help if you can provide a sample file. Br, Anders

Hi Marty, True, TEXTJOIN came with Excel 2016 version. I hope you get it to work as you want it to be. Br, Anders

Hi Jim, I don't really have a solution to offer for you, as I am not to much of a big fan of using VBA, even though it is handy from time to time. ...

Hi, The problem seem to be with Windows 10 and display language set to Swedish (and possibly other languages as well). As the pictures shows it wor...

Hi Catalin, Yes, it is a Swedish version. I am using the English language pack though. I will do some test later on with switching Windows language...

Hi Helene, Apart from that you will get a #N/A result when the condition is false, as you have not completed the IF formula to handle such scenario...

Hi Marty, When you combine text and numbers in one cell like you do here Excel treats it as text, even the numbers. Below is an example of how you ...