| A | B | C | D | E | F | G | ||
|---|---|---|---|---|---|---|---|---|
1 | Text | Expected | by APL | Custom function | Should work if there is guaranteed only one valid match? | Same as col E, as an array formula | Custom function by Kishan | |
2 | aaa | 0 | 2 | #NAME? | 0 | 00 | 0 | |
3 | red | 2 | dog | #NAME? | 2 | 22 | 2 | |
4 | dog | perro | dog | #NAME? | dog | dog | perro | |
5 | home | casa | home | #NAME? | home | home | casa | |
6 | Red | 1a | 2 | #NAME? | 2 | 22 | 1a | |
7 | Black | 22 | 0 | #NAME? | Black | 0101 | 22 | |
8 | White | 123ca | 02 | #NAME? | White | 0202 | 123ca | |
9 | adddaa | aaaa | azaa | #NAME? | azaa | adddaa | aaaa | |
10 | dog | perro | dog | #NAME? | dog | dog | perro | |
11 | home | casa | home | #NAME? | home | home | casa | |
12 | the home of the dog | "dragon & gas" hello | the home of the dog | the home of the dog | the home of the dog | "dragon & gas" hello | ||
13 | 4 ØsterÃ¥gade | aeiou | 4 Østerågade | #NAME? | 4 ØsterÃ¥gade | 4 ØsterÃ¥gade | aeiou | |
14 | 123 | 123 | ||||||
15 | 110 | 0 | 110 | 0 | ||||
16 | 165 | 2 | AAA | 165 | 2 | |||
17 | dog | dog | ||||||
18 | home | aaa | home | |||||
19 | 2 | 2 | ||||||
20 | Black | Black | ||||||
21 | White | White | ||||||
22 | azaa | azaa | ||||||
23 | dog | dog | ||||||
24 | home | home | ||||||
25 | the home of the dog | the home of the dog | ||||||
26 | 4 Østerågade | 4 Østerågade | ||||||
27 | 123 | 123 | ||||||
28 | ger den nn swe and 0 | 110 | GE den nn swe and 0 | GEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE0GE | 110 | |||
29 | ger den nn swe and 1 | 165 | #NAME? | GEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE1GE | GEGE GEdGEeGEnGE GEnGEnGE GEGE GEaGEnGEdGE GE1GE | 165 | ||
30 | 145 | 145 | 145 | |||||
31 | 32 | 32 | ||||||
32 | ||||||||
33 | 32 | #NAME? | 32 | |||||
34 | 11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry | #NAME? | 11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry | |||||
35 | ||||||||
36 | ||||||||
37 | ||||||||
38 | ||||||||
39 | ||||||||
40 | ||||||||
41 | ger den nn swe and 0 | ger den nn swe and 0 | ||||||
42 | ger den nn swe and 1 | ger den nn swe and 1 | ||||||
43 | 145 | 145 | ||||||
44 | 32 | 32 | ||||||
45 | ||||||||
46 | 32 | 32 | ||||||
47 | 11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry | 11214=6&entry.1975707177=6&entry.742827012=6&entry.632681597=6&entry.1565772396=6&entry |