Last seen: Jul 6, 2025
Hello, Velouria's code gives a better result. But to answer your question, you got the expected result for that text split code, so nothing missed ...
Hello, A similar question was asked in this post, for me the suggested approach works just fine, check if it works for you.
Hello Dina, Welcome to MOTH. You can find more useful information here on how to work with date/time in Excel. If you are familiar to Power Q...
Hello, I suppose the original documentation about this connector can give some guidance. If not then perhaps this site has some useful info. Br,...
Hello, Not sure if I understand your issue properly, but as has been done with the Parameter table for the ID you need to do the same for the SBU_C...
Hello Benn, In attached file I have created a minor example of the approach I suggested earlier. I don't know if this approach suits you or not, bu...
Hello Benn, Your file was uploaded. I am soon leaving home for a short vacation trip, but it means I will be offline till Friday. Let’s see if some...
Hello Bobbe, I doubt this is due to Excel or the slicers in the file. If this happens regardless what programs you run, do check your mouse options...
Hello Benn, Do try to upload your file again, do remove the %20 in the file name first. Br, Anders
Hello Kiran, See attached file for a formula solution, I have renamed and rearranged your data range to make it a little bit easier for me to work ...
Hello, Don't know why think this is an Excel related question. I searched the Internet for "store inventory sample" and got some suggestions. Do th...
Can you share your file?
Hello Benn, Welcome to this forum. It is not a small thing you ask help with, but let’s give it a try. I suggest you build a lookup table first,...
Hello, Thanks Graham for correcting my error. In Swedish the separator is the semicolon, so when I paste in a formula copied from Excel I have to c...
Well, the error seems not to be in the JSON file, but perhaps in your Excel file. If you haven’t already, do try to import the JSON data in a new empt...