Update2: Changing all commas (,) to semicolons (;) gives me "Could not find a matrix value."
Update1: The formula that Rubén suggests:
Gets me this error. Any suggestions?
I have a Google sheet with 100 rows (individuals) and the following columns:
NAME (A) BIRTHDAY (B) BIRTHPLACE (C) TIME OF DEATH (D) PLACE OF DEATH (E)
I would like to create a formula in a new column (F) that outputs the value 1 if a person has the same NAME, BIRTHDAY and BIRTHPLACE or NAME, TIME OF DEATH and PLACE OF DEATH. Otherwise the output value should be 0.
Is this possible and if yes, how?