I am interested in looking at sets of rows with common account numbers, and assigning a 1 to a field in these rows if another field is true in any of these rows. To be more specific, I have fields called [Account Number], [field1] and [Production Date] - there are several rows for each Account Number since there's one for each production date. I need to figure out an efficient way to determine if field1 is ever true for each Account Number's set of rows and if so, I would like to assign a 1 to a field2 for every single one of those account numbers.
Basically this would flag every row for each Account Number that once contained a 1 in field1. Does anybody know how this could be done in the script or in the actual worksheet?