Multi-Row Formula

[verde0903]

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

[binuacs]

@verde0903 One way of doing this

[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

[binuacs]

@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

[binuacs]

@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

[verde0903]

Here you go.  Thanks

[binuacs]

@verde0903 thanks, what is this macro? What does it actually?

[verde0903]

It converts UOM.  For your advise you can remove it.