Hessel de Walle's Blog

Data: A1:D12 filled with jan-dec: jan jan jan jan feb feb feb feb mar mar mar mar apr apr apr apr may may may may jun jun jun jun jul jul jul jul aug aug aug aug sep sep sep sep oct oct oct oct nov nov nov nov dec dec dec dec Example A AllText =A1:D12 &"" Adding &"" changes the whole name into one continuous array, reading from left to right and from top to bottom. We can use this in a graph (see Example A). We can not read the elements using the INDEX function like this: =INDEX(AllText;13) The INDEX does not see this as a continuous array. We still could use: =INDEX( AllText ;4;3) But there is nothing special about that. Example B ColumnText1 =...