Multi-Row Formula

Hello,

I am trying to identify the correct formula to use when there are several rows with same criteria and they need to be grouped together. In the example attached, the logic is that if Apple has a letter A under column Pile, if there is another row that has the word Apple but under Pile it is blank, then name it also as A.

Thanks,

Maylen

Bundling.xlsx

Developer Tools

Data Investigation

Database Connection

Accepted answers

All comments

binu_acs

@verde0903 One way of doing this

Multi_Row_161023.yxmd

verde0903

Thank you Binuacs for the quick response. This is exactly what I needed.

Regards,

Maylen

verde0903

Hi Binuacs,

One more question please. This portion is part of a larger workflow. If I just run that piece it gives me the desired result, but when I added it to the workflow in it's entirety it does not function as it should. Would you happen to know what would be causing that. I have tried several permutations but nothing works.

Regards,

Maylen

Bundling.JPG

binu_acs

@verde0903 the workflow that I provided was based on your input file, if you have different data the result would be different, would you be able to give me another test input file and the expected result that matches your original data?

verde0903

Hi Binuacs,

Here is the entire workflow.

Thank you,

Maylen

Test Bundling.yxmd

binu_acs

@verde0903 Can you send the workflow as a package (export the workflow options menu-export workflow) , so that i can run the entire workflow with the macros and input file