Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Sep 16, 2025
Topics: 61 / Replies: 1581
Reply
RE: Search for non-similar words in Excel

Hi Ali, I'm confused. The topic title is 'Search for non-similar words in Excel', but your post asks to find indentical sentences. Which one is i...

7 years ago
Reply
RE: Formula for excel

The filename has a % in it which is probably causing the 400 error. Aye - please make sure the filename consists of just letters/numbers Phil

7 years ago
Reply
RE: data cleansing

Nice work Sunny. Aye - attached is a VBA solution that uses RegEx in a UDF. You'll need to set a reference to the 'Microsoft VBScript Regular Expr...

7 years ago
Reply
RE: Dynamic drop down list with combo box

Hi Daniele, I've emailed you. Regards Phil

7 years ago
Reply
RE: data cleansing

Before I spend a lot of time on this, I have to ask, where does the data come from? Can't you do something at the source of the data to prevent the i...

7 years ago
Reply
RE: Automatic fill required cells

OK, please upload a workbook with this data so I can work with that.

7 years ago
Reply
RE: Formula Dsum in a sheet with combo box

Hi Carine, You can read how to use DSUM here Regards Phil

7 years ago
Reply
RE: Share Macro Enabled File on OneDrive

Hi Astrit, Yes I think you could log in to the same OneDrive account more than once, I haven't tried it. But you have the ability to share file ...

7 years ago
Forum
Reply
RE: Automatic fill required cells

If you want the value in E7 to be in F12:F62 then in F12:F62 you type =$E$7 Not sure what you mean by 'according required' but I think you might wa...

7 years ago
Reply
RE: Print layout problem

Hi Lea, You should be able to print the file on one page by adjusting the print settings or page setup, e.g. In your print dia...

7 years ago
Reply
RE: How to get newest file from folder

When you are writing your reply, there's a button below the box you are typing in marked 'Attachments'. Click on that and then on 'Add Files' and sel...

7 years ago
Forum
Reply
RE: Output a cell's information to a website

Hi Damon, I wouldn't use Excel for this. You'd be better off writing something in the languages supported by the CoinGecko API like NodeJS or Pytho...

7 years ago
Reply
RE: Can't find library or project error message

You may have a missing reference. In the VBA editor go to Tools->References and look through the list for anything marked MISSING. If you find ...

7 years ago
Forum
Reply
RE: Error scraping web data. Help with the VBA code

Hi Peter, Can you please supply the workbook with the data to be used in Step b, otherwise the form submission doesn't work. Please explain what...

7 years ago
Forum
Page 95 / 110