Hi For each SEQ in coloum B i want to fill values from coloumn C in F until next SEQ in B.
I have attached a small set of sample data.
Thanks in advance,
Hi @Hamder83
Here is how you can do it.Workflow:
Hope this helps : )
Can you provide this data in excel.
Argh, I thought i had 😕
@atcodedog05 you solution works. I just found out there is a small difference in my sample data and my acual data.I've atttached a of of sample data, as it looks.I thought i could just add a multi row formula, before the one you send..IF [1]="SEQ"
and
IsNull([Row-1:1])
THEN
"SEQ"
ELSE[1]
ENDIFTo move seq up a row, but it does not work.Does it make sense?
Did you give it a try.
And its seems the sample* data is again missed.
I cannot attache a file to save my life.
I want the red Agreement in A to be WeightBreak, and same goes for WeightBreak further down.So I trid adding a formula replacing the blank value with SEQ in the previous row. And then do your formula. But it changed nothing?
@atcodedog05 , your a god! Thank you very much 🙂 This just made my design much more dynamic, I love it, thank you 🙂
Happy to help : ) @Hamder83 Cheers and have a nice day!
