Forum

Hello, It seems the sample file didn’t get uploaded. Br; Anders

Hello, =TEXTJOIN(",",TRUE(),IF(($I$3:$O$3)*(ISNUMBER(I6:O6))<>0,($I$3:$O$3)*(ISNUMBER(I6:O6)),"")) Br, Anders

Hello, I assume you have Microsft 365. In G6, paste in following formula and then copy down. =TEXTJOIN(",",TRUE(),FILTER($I$3:$O$3,ISNUMBER(I6:O...

Hello, Check out the tip from Catalin in this post, it should help you to load data into Power Query regardless. Br, Anders

Hello, Just checking the support page Cognito Forms API - Cognito Forms should give you the answer you are looking for. I added some extra spaces i...

Hello, I asked Copilot. Don't know if it works though. Copilot Genererar svar åt dig… Skickades av Copilot: It look...

Hello, Have you considered using Power Query to load your data? You don't mention how your data is coming in to the workbook, other than you want t...

Hello, Perhaps not the answer you want, but is it possible adjusting the height and width beforhand? In that way the expected data is shown as expe...

Hello, No file attached, but there is no need to upload (unless I understood your query wrong). Do check out the blog article Excel Table Absolu...

Hello, Perhaps a Power Query solution is something that would work. Added a custom column using Date.ToText. = Table.AddColumn(#"Omsorterade kol...

Hello, You can use different FUNCTIONS to lookup and fetch a value. XLOOKUP SUMPRODUCT INDEX & MATCH See attached copy of your sample...

Hello, Not a fully correct result, but perhaps it can be adjusted further. I am not good with VBA so I haven't checked for such solution. Asking...

Hello, A simple method for one such array is =IF(SEQUENCE(K8),J8) The problem is how to combine it with several rows. I would like to try usi...

Hello, See if you can find a solution from How to correct a #REF! error - Microsoft Support. In your scenario I would use Power Query to get the...

Hello, For the month you can use Date.AddMonths function, then you don't have to handle 13 as a month, it will be 1. = if Date.Day([Date]) > ...