Spreadsheet: 839717d1692182551-extracting-single-text-from-array-get-value-from-array
Sheet: Extract text from array

 | Number value from column |  | Text from column |  | Number value from array |  |  |  |  |  |  | Text from array
 | False |  | False |  | False | False | False |  |  |  | False | False | False
 | False |  | False |  | False | False | False |  |  |  | False | False | False
 | False |  | False |  | False | False | 88 |  |  |  | False | False | HIPPOPOTAMUS
 | False |  | False |  | False | False | False |  |  |  | False | False | False
 | False |  | False
 | False |  | False
 | 88 |  | HIPPOPOTAMUS
 | False |  | False
 | False |  | False
 | False |  | False
 | False |  | False
 |  |  |  |  | ­
 |  |  | 2 |  | _x0001_ |  |  |  |  |  |  | =INDEX(A1:O23;MAX(IF(ISTEXT(L2:N5);ROW(L2:N5)));MAX(IF(ISTEXT(L2:N5);COLUMN(L2:N5))))
 |  |  | 3 |  | _x0002_
 |  |  | 4 |  | _x0003_
 |  |  | 5 |  | _x0004_
 |  |  | 6 |  | _x0005_ |  |  |  |  |  |  | =[NAME]:N5))
 |  |  | 7 |  | _x0006_
 |  |  | 8 |  | _x0007_
 |  |  | 9 |  | _x0008_
 |  |  | 10 |  | _x000E_
 |  |  | 11 |  | _x000F_
 |  |  | 12 |  | _x0010_
 |  |  | 13 |  | _x0011_
 |  |  | 14 |  | _x0012_
 |  |  | 15 |  | _x0013_
 |  |  | 16 |  | _x0014_
 |  |  | 17 |  | _x0015_
 |  |  | 18 |  | _x0016_
 |  |  | 19 |  | _x0017_
 |  |  | 20 |  | _x0018_
 |  |  | 21 |  | _x0019_
 |  |  | 22 |  | _[NAME]_
 |  |  | 23 |  | _x001B_
 |  |  | 24 |  | _[NAME]_
 |  |  | 25 |  | _x001D_
 |  |  | 26 |  | _x001E_
 |  |  | 27 |  | _[NAME]_
 |  |  | 28 |  | 
 |  |  | 29 |  | '
 |  |  | 30 |  | -
 |  |  | 31 |  | –
 |  |  | 32 |  | —
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
 |  |  | 37 |  | _x000B_
 |  |  | 38 |  | _x000C_
 |  |  | 39 |  | _x000D_
 |  |  | 40 |  | !
 |  |  | 41 |  | "
 |  |  | 42 |  | #
 |  |  | 43 |  | $
 |  |  | 44 |  | %
 |  |  | 45 |  | &
 |  |  | 46 |  | (
 |  |  | 47 |  | )
 |  |  | 48 |  | *
 |  |  | 49 |  | ,
 |  |  | 50 |  | .
 |  |  | 51 |  | /
 |  |  | 52 |  | :
 |  |  | 53 |  | ;
 |  |  | 54 |  | ?
 |  |  | 55 |  | @
 |  |  | 56 |  | [
 |  |  | 57 |  | \
 |  |  | 58 |  | ]
 |  |  | 59 |  | ^
 |  |  | 60 |  | ˆ
 |  |  | 61 |  | _
 |  |  | 62 |  | `
 |  |  | 63 |  | {
 |  |  | 64
 |  |  | 65 |  | }
 |  |  | 66 |  | ~
 |  |  | 67 |  | ¡
 |  |  | 68 |  | [NAME]
 |  |  | 69 |  | ¨
 |  |  | 70 |  | ¯
 |  |  | 71 |  | ´
 |  |  | 72 |  | ¸
 |  |  | 73 |  | ¿
 |  |  | 74 |  | ˜
 |  |  | 75 |  | ‘
 |  |  | 76 |  | ’
 |  |  | 77 |  | [NAME]
 |  |  | 78 |  | “
 |  |  | 79 |  | ”
 |  |  | 80 |  | „
 |  |  | 81 |  | ‹
 |  |  | 82 |  | ›
 |  |  | 83 |  | ¢
 |  |  | 84 |  | £
 |  |  | 85 |  | ¤
 |  |  | 86 |  | ¥
 |  |  | 87 |  | €
 |  |  | 88 |  | +
 |  |  | 89 |  | <
 |  |  | 90 |  | =
 |  |  | 91 |  | >
 |  |  | 92 |  | ±
 |  |  | 93 |  | «
 |  |  | 94 |  | »
 |  |  | 95 |  | ×
 |  |  | 96 |  | ÷
 |  |  | 97 |  | §
 |  |  | 98 |  | ©
 |  |  | 99 |  | ¬
 |  |  | 100 |  | ®
 |  |  | 101 |  | °
 |  |  | 102 |  | µ
 |  |  | 103 |  | ¶
 |  |  | 104 |  | ·
 |  |  | 105 |  | …
 |  |  | 106 |  | †
 |  |  | 107 |  | ‡
 |  |  | 108 |  | •
 |  |  | 109 |  | ‰
 |  |  | 110 |  | 
 |  |  | 111 |  | 
 |  |  | 112 |  | 
 |  |  | 113 |  | 
 |  |  | 114 |  | 
 |  |  | 115 |  | 0
 |  |  | 116 |  | [NAME]
 |  |  | 117 |  | ½
 |  |  | 118 |  | ¾
 |  |  | 119 |  | 1
 |  |  | 120 |  | ¹
 |  |  | 121 |  | 2
 |  |  | 122 |  | ²
 |  |  | 123 |  | 3
 |  |  | 124 |  | ³
 |  |  | 125 |  | 4
 |  |  | 126 |  | 5
 |  |  | 127 |  | 6
 |  |  | 128 |  | 7
 |  |  | 129 |  | 8
 |  |  | 130 |  | 9
 |  |  | 131 |  | A
 |  |  | 132 |  | a
 |  |  | 133 |  | ª
 |  |  | 134 |  | Á
 |  |  | 135 |  | á
 |  |  | 136 |  | À
 |  |  | 137 |  | à
 |  |  | 138 |  | Â
 |  |  | 139 |  | â
 |  |  | 140 |  | Ã
 |  |  | 141 |  | ã
 |  |  | 142 |  | B
 |  |  | 143 |  | b
 |  |  | 144 |  | C
 |  |  | 145 |  | c
 |  |  | 146 |  | Ç
 |  |  | 147 |  | ç
 |  |  | 148 |  | D
 |  |  | 149 |  | d
 |  |  | 150 |  | Ð
 |  |  | 151 |  | ð
 |  |  | 152 |  | E
 |  |  | 153 |  | e
 |  |  | 154 |  | É
 |  |  | 155 |  | é
 |  |  | 156 |  | È
 |  |  | 157 |  | è
 |  |  | 158 |  | Ê
 |  |  | 159 |  | ê
 |  |  | 160 |  | Ë
 |  |  | 161 |  | ë
 |  |  | 162 |  | F
 |  |  | 163 |  | f
 |  |  | 164 |  | ƒ
 |  |  | 165 |  | G
 |  |  | 166 |  | g
 |  |  | 167 |  | H
 |  |  | 168 |  | h
 |  |  | 169 |  | I
 |  |  | 170 |  | i
 |  |  | 171 |  | Í
 |  |  | 172 |  | í
 |  |  | 173 |  | Ì
 |  |  | 174 |  | ì
 |  |  | 175 |  | Î
 |  |  | 176 |  | î
 |  |  | 177 |  | Ï
 |  |  | 178 |  | ï
 |  |  | 179 |  | J
 |  |  | 180 |  | j
 |  |  | 181 |  | K
 |  |  | 182 |  | k
 |  |  | 183 |  | L
 |  |  | 184 |  | l
 |  |  | 185 |  | M
 |  |  | 186 |  | m
 |  |  | 187 |  | N
 |  |  | 188 |  | n
 |  |  | 189 |  | Ñ
 |  |  | 190 |  | ñ
 |  |  | 191 |  | O
 |  |  | 192 |  | o
 |  |  | 193 |  | º
 |  |  | 194 |  | Ó
 |  |  | 195 |  | ó
 |  |  | 196 |  | Ò
 |  |  | 197 |  | ò
 |  |  | 198 |  | Ô
 |  |  | 199 |  | ô
 |  |  | 200 |  | Õ
 |  |  | 201 |  | õ
 |  |  | 202 |  | Œ
 |  |  | 203 |  | œ
 |  |  | 204 |  | P
 |  |  | 205 |  | p
 |  |  | 206 |  | Q
 |  |  | 207 |  | q
 |  |  | 208 |  | R
 |  |  | 209 |  | r
 |  |  | 210 |  | S
 |  |  | 211 |  | s
 |  |  | 212 |  | Š
 |  |  | 213 |  | š
 |  |  | 214 |  | ß
 |  |  | 215 |  | T
 |  |  | 216 |  | t
 |  |  | 217 |  | Þ
 |  |  | 218 |  | þ
 |  |  | 219 |  | ™
 |  |  | 220 |  | U
 |  |  | 221 |  | u
 |  |  | 222 |  | Ú
 |  |  | 223 |  | ú
 |  |  | 224 |  | Ù
 |  |  | 225 |  | ù
 |  |  | 226 |  | Û
 |  |  | 227 |  | û
 |  |  | 228 |  | V
 |  |  | 229 |  | v
 |  |  | 230 |  | W
 |  |  | 231 |  | w
 |  |  | 232 |  | X
 |  |  | 233 |  | x
 |  |  | 234 |  | Y
 |  |  | 235 |  | y
 |  |  | 236 |  | Ý
 |  |  | 237 |  | ý
 |  |  | 238 |  | Ÿ
 |  |  | 239 |  | ÿ
 |  |  | 240 |  | Ü
 |  |  | 241 |  | ü
 |  |  | 242 |  | Z
 |  |  | 243 |  | z
 |  |  | 244 |  | Ž
 |  |  | 245 |  | ž
 |  |  | 246 |  | Æ
 |  |  | 247 |  | æ
 |  |  | 248 |  | Ä
 |  |  | 249 |  | ä
 |  |  | 250 |  | Ø
 |  |  | 251 |  | ø
 |  |  | 252 |  | Ö
 |  |  | 253 |  | ö
 |  |  | 254 |  | Å
 |  |  | 255 |  | å