Evaluating multiple rows across unique ID

@mystasz
@ArtApa gives a very smart solution, but I would also like to presenta pretty length one but I believe which is more straightforwad and maybe easy to modify when you have some input changes.
I used two Batch Macro to list up the Combination of Values for each ID and name then do the conditional checking.

0621-MysticalAz.yxzp

All comments

messi007

@mystasz,

Please see below :

Attached the workflow,

Regards,

Violation.yxmd

mystasz

Hello and thank you. The formula used is applying "OR" logic and evaluating each row individually. For 1 AND 4, this logic would say its a violation if only 1 existed and not 4. Both 1 and 4 need to exist for a single ID.

If you change the number 4 to a 20 for ST01, it's still assigning Violation 1 which would be untrue based on the logic.

ArtApa

Hi @mystasz - Here is how you can achieve a desired outcome:

ViolationAA.yxmd

mystasz

This worked perfectly! Thank you

Qiu

0621-MysticalAz.yxzp

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167