Last seen: Jun 9, 2026
Hi Henrik, coin_price_rtd is the Python function I wrote and this is stored in the file moth_coin_rtd.py. Open moth_coin_rtd.py and you'll see the...
Hi Pa, The data laid out in your screenshot isn't the same as the data in the workbook you provided. The workbook I'm attaching here duplicates ...
Hi Henrik, Where did you get this error? In Excel? Pleas supply screenshots. If you have the name(s) of the module(s) in the PyXLL config file...
Hi Yousef, Please start your own topic, don't tag on to the end of an existing one 🙂 Attached is a workbook that does what you requested. I've...
Hi Rob, As I don't have a Mac there's no way for me to integrate my code with Ron's and test that it works. You can try contacting Ron and seein...
Hi Henrik, Have you added the Python module names to your pyxll.cfg file as described here: Regards Phil
Pa, Without seeing how you are trying to use the formula it's impossible to say why you are getting that result. I asked how do you want the Hom...
Hi, Do you mean how do you make an absolute reference to a cell? This post explains Absolute References Regards Phil
Hi John, Please attach a workbook with your data when posting. Saves you and us typing everything in again. Please see attached file. I've c...
Hi Pa, So how do you want the Home and Away columns to affect the calculation? What exactly are you trying to calculate? I have a feeling t...
Wayne, Please attach your workbook. I emailed you directly yesterday asking you to do this. The 2 in SUBSTITUTE indicates which instance of the...
Hi Andy, You can raise a ticket on the Helpdesk which will not be publicly seen. Cheers Phil
Thanks. Did my formula do what you needed? Regards Phil