Jul 01 2020 01:52 AM
In the below image, I know the values which are A, B, C, ...H but I wont be having the values for 1 2 3 .. n
How can i capture the random values out of the fixed in a cell?
NOTE: All the variable is a "text" and the order of A, B, 1 doesn't remain the same.
Any function to capture the random value will help
Jul 01 2020 12:07 PM
That could be
=SORT(FILTER(
FILTERXML("<r><n>" & SUBSTITUTE(TEXTJOIN(",",,A:A),",","</n><n>") & "</n></r>", "//n"),
ISTEXT(FILTERXML("<r><n>" & SUBSTITUTE(TEXTJOIN(",",,A:A),",","</n><n>") & "</n></r>", "//n"))
))
for