Tag Archives: offset

Excel functions that return references and new functions

Posted on 30/06/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 20/02/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

	py_ConBeamU and Stra… on py_ConBeamU
	py_ConBeamU and Stra… on ConBeamU and Strand7 check…
	ConBeamU and Strand7… on Using ConbeamU
	ConBeamU and Strand7… on ConBeamU 4.08…
	dougaj4 on The TrimRange Function
	khoitsma on The TrimRange Function
	py_UMom 1-05 \| Newto… on py_UMom 1.04
	py_UMom 1.04 \| Newto… on py_UMom spreadsheet and OptShe…
	Mandelbrot, Mojo, Nu… on Computing and plotting the Man…
	py_Numpy update 2: P… on Numpy where and split, and py_…
	Numpy where and spli… on Scipy functions with Excel and…
	py_RC Elastic 1.05 w… on Elastic Biaxial Bending
	py_RC Elastic 1.05 w… on py_RC Elastic 1.04 and fatigue…
	ConBeamU update \| Ne… on Using ConbeamU
	dougaj4 on Using ConbeamU

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