Forum Discussion
ARRAY CONSTANTS, not working
buffer size {150,200,300,400,500,650,700} Buffer 419 ltr Hello, I entered my array constant in a single Excel Spreadsheet Cell, see above. Then I "named" the cell (Excel/For...
Hi Patrik
First of all... why wold you enter a list of values in an array in a cell (but as text)???
The simple solution would be entering the values in individual cells (e.g. B4:B10).
=LOOKUP(B1+AGGREGATE(15,6,ABS(B4:B10-B1),1)*{-1;1},B4:B10)In B1 is the calculated buffer size.