Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 9, 2026
Topics: 61 / Replies: 1588
Reply
RE: Error Code #Name when using Pyxll and Python

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...

6 years ago
Reply
RE: Adding new criteria to old criteria in SUMPRODUCT

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 ...

6 years ago
Reply
RE: Error Code #Name when using Pyxll and Python

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...

6 years ago
Reply
RE: Send Multiple PDF by Outlook Email from Excel

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...

6 years ago
Forum
Reply
RE: Automatically email multiple PDF documents from one sheet that has a dropdown list

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...

6 years ago
Forum
Reply
RE: Error Code #Name when using Pyxll and Python

Hi Henrik, Have you added the Python module names to your pyxll.cfg file as described here: Regards Phil

6 years ago
Topic
Forum
Replies: 8
Views: 958
Reply
RE: Adding new criteria to old criteria in SUMPRODUCT

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...

6 years ago
Reply
RE: Absolute

Hi, Do you mean how do you make an absolute reference to a cell? This post explains Absolute References Regards Phil

6 years ago
Reply
RE: counting multiply criteria ranges

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...

6 years ago
Reply
RE: Adding new criteria to old criteria in SUMPRODUCT

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...

6 years ago
Reply
RE: formula to remove duplicate wording in columns

Wayne, Please attach your workbook. I emailed you directly yesterday asking you to do this. The 2 in SUBSTITUTE indicates which instance of the...

6 years ago
Reply
RE: Barcode Help

Hi Andy, You can raise a ticket on the Helpdesk which will not be publicly seen. Cheers Phil

6 years ago
Forum
Reply
RE: Adding new criteria to old criteria in SUMPRODUCT

Thanks. Did my formula do what you needed? Regards Phil

6 years ago
Page 70 / 110
0