When A1 ≠ A2 and C1 = C2, B1 = A2 or B2 = A1 (2) when A1 ≠ A2 and C1 = C2, D1 = E2 or D2 = E1 There are many repeated values in column a, many repeated values in column C, many repeated values in column e, and null values in columns B and D

When A1 ≠ A2 and C1 = C2, B1 = A2 or B2 = A1 (2) when A1 ≠ A2 and C1 = C2, D1 = E2 or D2 = E1 There are many repeated values in column a, many repeated values in column C, many repeated values in column e, and null values in columns B and D

1、 When A1 ≠ A2 and C1 = C2, B1 = A2 or B2 = A1
=And (and (A1A2, C1 = C2), or (B1 = A2, B2 = A1)) * value
2、 When A1 ≠ A2 and C1 = C2, D1 = E2 or D2 = E1
=And (and (A1A2, C1 = C2), or (D1 = E2, D2 = E1)) * value

Elden Ring Premiere

RELATED INFORMATIONS