lundi 27 juin 2016

Return value when three conditions are met in an row

System   DB    Type  Result
  1      DB1    Q1
  1      DB1    Q2
  1      DB2    Q1
  1      DB2    Q1

I would like a formula that returns a 1 in the 'Result' column if any other row has the same system ID, the same DB ID but a different ID in the Type column. Any help greatly appreciated. Thanks

Aucun commentaire:

Enregistrer un commentaire