Last seen: Aug 24, 2025
No worries!
This is what I see when I connect PQ to the CSV, columns A and B. It all seems to line up pretty good, though it probably need som work to clean it up...
Understood!!
The CSV didn't come through. Please try again. This time don't forget to press 'Start upload' and wait until it's complete before submitting your repl...
What exactly do you mean by text in "wrap" format? Can you upload and example of a CSV file with such data?
I believe this CF formula works for you, applied to I5: =AND(ISBLANK($I$5),$I$6+5<TODAY())
Just in case a PQ solution is still considered an option, and to avoid that the file link above expires, I believe I can now upload the file.
I would prefer a solution with Power Query where you can do a few merge/expand steps to 'join' the values for the codes with the codes "from" and "to"...
I assume you are somewhat familiar with Power Query. Then the script I have pasted below is a very basic way of unpivoting and transforming the data i...
I'm not a Python person, but by looking at your desired end result (the yellow area) I believe I understand what you are needing. I connected to th...
You should probably use one of Excel's lookup functions (LOOKUP, VLOOKUP, XLOOKUP, INDEX/MATCH). There are plenty to choose from. Please add some cont...
You see, I didn't even understand you solved the problem 🙂
Needed to reply to the lastest post in order to moderate it. Unfortunately, I'm in no position to help you with VBA 🙂