<tbody>
Please see below table. I'm trying to assign an "X" in column NIS2 when any record sharing the same TRANS ID (column A) has an "X" in column NOT IN STOCK. My obstacle is some times the NOT IN STOCK column "X" may be the first, middle or last record for a given TRANS ID. My attempts...