Multirow formula up and down!

[Bigmonki]

Hi,

I am getting to grips with Multirow formulas slowly! I have almost mastered the art of populating data going down a column, but now I need to go up and down.

So I have multiple companies that have 549 records in a set, I have grouped them already using a CEIL formula but now I need to set a company value. I would like the formula to read the group, find COMPANY in the KeyName column, the for all of the rows in the group set a Company number based on the "Value" filed for the COMPANY record. The rows in the group extend above and below the COMPANY, so I need to go up and down.

[RolandSchubert · Accepted solution]

Hi @Bigmonki ,

I would select the rows containing "COMPANY" as a key, calculate the respective range  (if it's not already done by "Group" and use a Find Replace tool to add the company. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland