Simple multi field formula

[Hamder83]

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, 

[atcodedog05]

Hi @Hamder83 

Can you provide this data in excel.

[Hamder83]

Argh, I thought i had 😕

[atcodedog05]

Hi @Hamder83 

Here is how you can do it.

Workflow:

Hope this helps : )

[Hamder83]

@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]

ENDIF


To move seq up a row, but it does not work.


Does it make sense?

[atcodedog05]

Hi @Hamder83 

Did you give it a try.

And its seems the sample* data is again missed.

[Hamder83]

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 · Accepted solution]

Hi @Hamder83 

Here is how you can do it.

Workflow:

Hope this helps : )

[Hamder83]

@atcodedog05 , your a god! Thank you very much 🙂 

This just made my design much more dynamic, I love it, thank you 🙂 

[atcodedog05]

Happy to help : ) @Hamder83 

Cheers and have a nice day!