jeffreyweir
Active Member
Formula Challenge 013 - Turn non-contiguous cells into a 1D range
Challenge setup
Put the letter x in F7, and assign the name ‘x’ to it
Put the letter y in J6, and assign the name ‘y’ to it
Put the letter z in L18, and assign the name ‘z’ to it
Now write a formula that turns those three separate references into a 1D array i.e. {"x","y","z"} and enter it over a one row by three column array.
No helper cells, no VBA, no working on this at 3am.
See if you can answer this by the end of TODAY()
My formula: 141 characters.
Challenge setup
Put the letter x in F7, and assign the name ‘x’ to it
Put the letter y in J6, and assign the name ‘y’ to it
Put the letter z in L18, and assign the name ‘z’ to it
Now write a formula that turns those three separate references into a 1D array i.e. {"x","y","z"} and enter it over a one row by three column array.
No helper cells, no VBA, no working on this at 3am.
See if you can answer this by the end of TODAY()
My formula: 141 characters.