Author Archives: dougaj4

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 , , , , , , , , , | 1 Comment

XY Chart problems – 2

Posted on 16/06/2020 by dougaj4

The previous chart post (XY Chart problems – 1) looked at problems plotting charts with very short data ranges.  An associated problem is plotting XY charts with data with gaps (see When is an XY chart not an XY chart …? and … Continue reading →

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA | Tagged , , , , , , | Leave a comment

The Drover’s Boy

Posted on 12/06/2020 by dougaj4

Ted Egan

Posted in Bach | Tagged , | Leave a comment

XY Chart problems – 1

Posted on 12/06/2020 by dougaj4

I have looked at problems with XY charts displaying as Line charts previously at: When is an XY chart not an XY chart …? and Plotting Charts With Gaps … The charts shown below. and also in the next post, can be … Continue reading →

Posted in Charts, Charts, Excel | Tagged , , | 1 Comment

For Bert Jansch – Around the World in 80 Plays

Posted on 30/05/2020 by dougaj4

I have been listening to Pierre le Bras on YouTube for some time, where he plays under the name of Old Picker.  Today a link from there led me to For Bert Jansch , hosted by The Bert Jansch Foundation: Musicians … Continue reading →

Posted in Bach | Tagged , , , , , , | 1 Comment