Recent Comments
Category Archives: Computing – general
Cleaning Data – Sort functions and shortcuts
Back in 2020 I posted here on New sort functions and sorting to groups, looking at using the sort functions to clean data. Revisiting that post I found that the link to the sample spreadsheet was broken, and that is now … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Excel and pdfs, Shortcuts for cleaner data, Sort Functions
Leave a comment
FeedSpot
Feedspot is a blog database with a huge list of different categories, each with listings of the best blogs, including: 60 Best Excel Blogs to Follow in 2026 with a wide range of blogs, including: For a complete list of … Continue reading
The Ultimate Python Guide for VBA Developers
I recently discovered “The Ultimate Python Guide for VBA Developers” which is a free book available from the pyxll site at https://www.pyxll.com/learn-python.html. The pyxll site says: This book has been written specifically for VBA and Excel users like you. Fast … Continue reading
Importing text files with Python and pyxll
VBA code to import text files to Excel was presented at Importing text files with VBA – 2 and following posts. We now look at Python code for a user defined function (UDF) for the same task. The code requires Python … Continue reading
Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs
Tagged Convert string to values, Excel, import text, Numpy, PyXLL, UDFs
Leave a comment
Python Match Case Statement
The Python match case statement was introduced in Python 3.10. It provides similar functionality to the VBA Select Case statement, but also has additional features. For detailed background with examples see: geekforgeeks – Python Match Case Statement The example below … Continue reading
Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs
Tagged Excel, match case statement, Python, PyXLL
Leave a comment
