Hi, I have a list of data in the 10-100's of thousands that changes weekly. I'm trying to find out if a unit has different data entered than the others in the group, on the same date. For example: ID Unit Field Date 1297 1 G02 04/09/2018 1297 1 G02 09/30/2018 1300 1 G04 03/01/2018 1300 2 G04 03/19/2018 1300 2 G04 08/01/2018 1304 1 G03 12/01/2018 1315 1 G01 01/23/2018 1315 2 G01 01/23/2018 1318 1 G02 06/05/2018 1318 1 G02 12/05/2018 1318 2 G02 06/05/2018 1318 2 G02 12/05/2018 1318 3 G07 06/05/2018 In the case above, I'd want a way to flag ID 1318, on 06/05/2018 because 2 of the units have G02, while the third has G07. Also, as an added difficulty step... some of the fields might start with something other than G. I want to ignore those from the comparison (so if a ID has 3 units, and 1 unit is P01, while other 2 are G01, it wouldn't need flagged) Any help on this would be greatly appreciated! Thank you!
... View more
