Search code examples
arraysexceloffset

EXCEL OFFSET formula with rows input as array

Does Excel's OFFSET() really not allow for array inputs on rows or col ? or am I just missing/not seeing something banal ?

enter image description here

{1\2} would be my expected result

Solution

  • SOLVED using N() around result - T() if result is text - if both ive used this: IF(T()="";N();T())

    NEW PROBLEM:

    (works if E1 is just a number instead of an array)

    enter image description here

    expected result: {2;4;6;8;10\12;14;16;18;20}

    anyone?