Help with multi-row formula for fill case using criteria

[aden08]

Hi community, I need your help to solve this problem, is using multi-row formula using Found_Crit and Help_Field and Sec. As you see in the next picture I feel using 1 If de SEC is descending(3,2,1) If is 1 Is not neccesary fill.

[binuacs · Accepted solution]

@aden08 One way of doing this

[aden08]

Thank u very much @binuacs but I have a question, is not possible the same results using Round or Help_Field, that is because that 1 is a Criteria during the analysis so sometimes the Sec(4,3,2,1) exist but without 1 that accomplish that criteria.

[binuacs]

@aden08 The expected result updating 1 or null based on the SEC value, but for the FOUND/Help field how would you do it manually? If you have any logic in your mind let me know I will try to implement that in the multi-row tool

[aden08]

Yes bro thank you very much, your help to found principally the SEC using the Uniq values, help me to using antoher multi-row formula, only to have that accomplish the Criteria of ROUND=1. This difference discrept when exist any SEC without HELP_FIELD=1