Last seen: Mar 8, 2026
Hello Mouna, If you search for export data into separate workbooks in whatever search engine you prefer you will get some examples, some also havin...
Hello Lea, It is quite simple when you get the hang of it. First, I defined in the Name Manager the list of names to check against as Lookup, if...
Hello, There is, to my knowledge, no other tool than find and replace, wheras you search for the old filename in the formulas and replace that with...
Hello Diane, If you can provide a sample file with this data that would be great. Br, Anders
Hello Salim, You will have to use custom number formatting or conditional formatting to get those symbols. Br, Anders
Hello, No Excel file attached, probably to big. I would say that Excel is not the best tool for this scenario, but with VBA code it can be done....
Hello, You can set this behaviour, check out this info at Microsoft support pages. Br, Anders
Hello Lea, Have a look in this blog article, it shows what needs to be done to consolidate many tables into one. Br, Anders
Hello Ali, With a helper column where you for example count how many times the individual names is found in your range, the formula to get what you...
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...