Last seen: Apr 30, 2025
I see what you want to do. Give me some time to think about it.
The file you intended to attach didn't come through. Please try again and don't forget to press 'Start Upload' before you submit your reply.
"However, the Contingency lines should not be circular, in that they do not calculate off of themselves. Contingency, Acquisition only references the ...
I don't think there is a way to avoid circular references here as you attempt to calculate a contingency as a percentage of a total that, in turn, sho...
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...