Tag Archives: Excel

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

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

New sort functions and sorting to groups

Posted on 16/05/2020 by dougaj4

I first posted a user defined function (UDF) to sort spreadsheet or VBA data back in 2009.  Finally Microsoft have caught up, and Excel 365 subscribers now have two built in sort functions available: =SORT(array,[sort_index],[sort_order],[by_col]) =SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…) … Continue reading →

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

Getting near matches from a list with Python

Posted on 19/04/2020 by dougaj4

To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple.  Here is the code for this operation, using pyxll to … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , | Leave a comment

Stepping through Python code called from Excel

Posted on 31/03/2020 by dougaj4

Setting up your editor to allow Python code debugging for functions called from Excel can be tricky, depending on the details of your editor and linking software, but using the Visual Studio Code Editor and Pyxll, this works for me: … Continue reading →

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs | Tagged , , , , | 4 Comments