Forum

Hi, Do you mean 70-778? Can't say any more than make sure you study everything you can and practice a lot. Do a lot of practical work. Can't h...

Hi Amit, The code in the workbook and the code in your image are not the same. I can run the code in the workbook you attached without issue. A...

Hi Alain, You can do this with a combination of INDEX, SUMPRODUCT and SEARCH. There's a blog post on how it works here Search a String for a Li...

Hi Robert, The link is at the top of the Grouping sheet in the workbook that comes with the course. Here's the link Regards Phil

Hi Maurizio, I've written some code to do what you want but it may need to be more robust as it checks for the occurrence of a string e.g. Blu with...

No worries 🙂

Hi Mark, Did you try to create the GPD formula for the 2nd PT manually? You can create a GPD formula by clicking on the cell in the PT that you wa...

Hi Stephen, I can think of more than one way this could be done but without seeing your data I don't know which way is best. Please attach your wo...

You're welcome.

Hi Rhee, Are you always looking for 3 factors? Will the total always be 9? When you say 'continuously generate' are you looking to find all facto...

Hi Rajsha, I wrote a post on interacting with webpages which may be of help to you Web scraping filling in forms But if the website uses...

Hi Sammy, Without seeing your workbook I can't give you my 'best' answer. I don't know what data you are trying to copy. Perhaps you could form...

Hi Rajsha, It sounds like you are trying to click a button on a web page to go to the next page and get the data on that next page. I'll need to...

Hi Rhee, If the value in B5 is fixed, then you are limited to the 'random' numbers you can use to in ColA that add up to the sum in B5. I don't se...

🙂 you're welcome