Tag Archives: offset

Excel functions that return references and new functions

Posted on June 30, 2020 by dougaj4

The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading →

Posted in Arrays, Excel | Tagged Choose, Excel, functions returning references, If, Ifs, Index, Indirect, offset, Switch, XLookup | 1 Comment

Slicing Arrays with VBA

Posted on February 20, 2015 by dougaj4

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged Excel, Index, offset, slicing arrays, UDF, VBA | 7 Comments

	Joyce B on ULS Design Functions and …
	py_Numpy update and… on More long numbers with Py…
	py_Numpy update and… on Calling Numpy polynomial funct…
	dougaj4 on Two views on VBA
	Lucas Beattie on Two views on VBA
	Lucas Beattie on ULS Design Functions – P…
	More long numbers wi… on A not so easy problem
	Shan Kumar on ULS Design Functions – P…
	dougaj4 on More updates to ArcSpline and…
	ULS Design Functions… on ULS Design Functions 2.16
	Jose Luna on More updates to ArcSpline and…
	Lucas Beattie on Drawing in Excel – …
	marcengineer on More on combined shear and ben…
	dougaj4 on More on combined shear and ben…
	Marc on More on combined shear and ben…

Tag Archives: offset

Excel functions that return references and new functions

Slicing Arrays with VBA

Categories

RSS Feed

Search NewtonExcelBach

Archives

Top Posts

Recent Comments

Blogroll

Family Links