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

[verde0903]

Hi Binuacs,

I was able to resolve the issue.  Thank you for your assistance.

Regards,

Maylen

[binuacs]

@verde0903 that is great!!! sorry I didn't get time to look into further.