I think you did it Purfleet! Thanks. It is working anyway and the helper column is the found I needed. Only think I must check now is if this is po...
Hi Velouria, Sunny, Just a message to let you know everything is working fine here as well! I tested it with an extract of the given data and that'...
OK we are some days further in time now, so I had the change to test everything proparly. I made this new file and put the data in a folder that's ...
Thanks again Velouria! I will test it in some days and let you know. Frans
Thanks very much Velouria! I don't know much about VBA, although I started several times with some courses. Somehow or somewhere we don't match ...
Thanks also for this reply Mynda. I read the article you refer to quickly and think I did everything properly. But I'll take a closer look about the e...
Thanks for answering and this idea Mynda. I didn't thought about that solution, maybe because I don't work often with the Power of Power Query. New...
And for some more information this oldy from Mynda here on the website: Frans
One can ask himself if this is something to be solved here? Did you try it yourself Ali and what did you encounter on problems or difficulties wher...
Nice link you found Sunny! I'll try that out to see if it also works in the Dutch version of Excel (you know sometimes…..). Thanks Frans
Hi Scotty, As I see it you are on the right track: converting is the way to do it. You can automise that maybe with VBA/Macro or try to duplica...