excel - Non-Native function returning an array - How to display the output -

i apologise if simple question, @ bit of loss here.

a bespoke formula want use returns array of values, seen here:

but cannot find way present output in cell separated format, first cell (39478) returned.

there note included in documentation: hint: function multiple result function. must set array output.

whilst understand going need array display multiple results, cannot find method of doing so. tips?

if bespoke formula wants return array of values, there couple of ways results multiple cells.

1. put formula cell , hit enter↵. next, select cell along several cells below it. tap f2 hit ctrl+shift+enter↵. successive values should fill cells selected until error (no more returns) reached.

2. put formula cell , hit ctrl+shift+enter↵. formula should wrapped in braces (e.g. { , }). if correct relative , absolute cell addresses used (e.g. $**a$1 or $**a1, etc) should able fill, copy or drag down formula successive rows.

3. use index function contain array of returned values bespoke formula , peel off successive values using row_num parameter.
         =index(<bespoke formula>, row(1:1))
     filled down.

sooner or later, run out of rows fill. iferror function used wrapper can avoid display of errors.

if want put of values single cell, user defined function (aka udf) concatenate array single string. last method not recommended renders values useless other display purposes.

---

_{array formulas need finalized ctrl+shift+enter↵. once entered first cell correctly, can filled or copied down or right other formula.}

_{array formulas chew calculation cycles logarithmically practise narrow referenced ranges minimum.}

_{see guidelines , examples of array formulas more information.}