Last seen: Jul 6, 2025
Hello, This looks like a school project, but you can use the INDIRECT function together with &"Slabs" to connect to the different slabs tables,...
Hello, The only solution I know of being reliable enough is to add numbers to the text you want to sort by. See attached file for an example. Br...
Hello, Just dropping by to write that I can not find any clue in your .xlsm file to why the description text gets truncated. I can not replicate th...
Hello, The Pivot Table (PT) only shows the data from the source table, so you need to change in the source and then update the PT to get the new va...
Hello, You should arrange your data in a tabular format, see example in attached file. If you want the layout as you have built in your table, then...
Hello, When importing the daily file to a new file it works just fine, I get over 1,000 characters without any issue. The same when I create severa...
Hello, Started to check my files where I know I have long text where many are 400+ characters and have luckily found no errors of this kind, in fac...
Hello, Looked around on this topic and found an explanation on this site: This behavior is determined by the the predictive nature of the Exce...
Hello, Can you share a sample file with some dummy data and also a mockup of what you want to achieve, that would make it easier to help you. Br...
Hello, Great that it works and thanks for your update, I have avoided such scenarious but with your example I see that it can actually work. Br,...
Hello, Normally you avoid to write formulas resulting in a circular reference, but there is an option to more or less allow such. See if enabling i...
Hello, Have you seen this article about get files from folder? Br, Anders
Hello, Thanks for the new sample file. Just wondering, did you check the modified sample file I uploaded in my previous post? I am asking because w...
Hello, I am sorry, but I can't follow your steps with the sample file you have attached. For example, in sheet Data, cell E8, the value is todays d...
Hello, It is easier for everyone if there is a sample file showing the data structure to look at, can you share such file? Br, Anders