Hello Sir, I need your help. I want a formula that if • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated Please Reply Sir
Excellent and it looks so simple! If I might suggest, could you preface the announcement of the videos in your email to advise the version/s of Excel to which the tutorial relates and functions (eg, 2021 v 365). Someone else mentioned "data scraping" ~ what if the website requires login and password (eg, for a bank statement or share/stock portfolio)?
Thank you! And thank you for the feedback. For the login and password, a window should appear asking for authentication when you connect to the site for the first time.
Thank you Allan! Very nice examples. But what if your webpage displays only 25 rows and you have to click on " next" . Would that also be possible? Maybe something with "web scraping"? I fyou know more, please show this to the world.... Oh, and next time you also are in the list of most viewed youtubers? 😉
Is it possible to insert only one data from the website, like the price of my brand watch, not entire website? I want to insert one data into one excel cell
Sure! You would either identify the table of data such as the list of watches, then in Power Query filter for the one you want (could even make this dynamic from Excel for the user) and delete all other columns leaving only the price to be imported. Or you could use the From Examples that I did in the second demo to write the code and bring in the necessary price.
Please help me I have Two workbooks of around 18 MB which is .XLS files saved as web page in my PC when I do import data from these files it took very long time but when I change them to Excel workbook type it become superfast in loading in power query but I have multiple files also it is repetitive task and file can be only downloaded in web page type. Only ...😢
@@ankursharma6157 I have Office 365, version Microsoft 365 MSO (versión 2403 compilación 16.0.17425.20236) 64 bits, and I don't have this feature yet and no updates available.
![ILLSLICK - THE KING'S LANDING [Freestyle]](http://i.ytimg.com/vi/feIJJnNkTfk/mqdefault.jpg)
The second scenario was a great eyeopener. thanks for sharing.
You're very welcome, Samuel.
Wow! That's great and didn't know about it at all. The transform by example is super. Thanks a lot!
My pleasure, Erica.
Thank you Alan. The old navigator window was a pain, good to see improvements in this area inside PQ - I would use it more often!
Cheers, Gareth
Thank You!
You're welcome!
How to extract the excel table from website with colours of each column is there any options ?
Pretty good, ill have to try
Please do!
Thank you very much!...
You're very welcome
Hello Sir, I need your help.
I want a formula that if
• if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated
• If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated
• if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated
Please Reply Sir
Excellent and it looks so simple! If I might suggest, could you preface the announcement of the videos in your email to advise the version/s of Excel to which the tutorial relates and functions (eg, 2021 v 365). Someone else mentioned "data scraping" ~ what if the website requires login and password (eg, for a bank statement or share/stock portfolio)?
Thank you! And thank you for the feedback.
For the login and password, a window should appear asking for authentication when you connect to the site for the first time.
@@Computergaga Yes, thanks Alan. But can the login process be completed programmatically?
Thank you Allan! Very nice examples. But what if your webpage displays only 25 rows and you have to click on " next" . Would that also be possible? Maybe something with "web scraping"? I fyou know more, please show this to the world.... Oh, and next time you also are in the list of most viewed youtubers? 😉
Thank you, Bart ☺️
Is it possible to insert only one data from the website, like the price of my brand watch, not entire website? I want to insert one data into one excel cell
Sure! You would either identify the table of data such as the list of watches, then in Power Query filter for the one you want (could even make this dynamic from Excel for the user) and delete all other columns leaving only the price to be imported.
Or you could use the From Examples that I did in the second demo to write the code and bring in the necessary price.
Please help me I have Two workbooks of around 18 MB which is .XLS files saved as web page in my PC when I do import data from these files it took very long time but when I change them to Excel workbook type it become superfast in loading in power query but I have multiple files also it is repetitive task and file can be only downloaded in web page type. Only ...😢
I use web connector for loading web page type from your trick of multiple web page data import video .
Is this only in beta channels?
It is out in General Release. If you have 365, and it's not there yet, it will be very soon.
It has been in beta for months.
Hi @zachg.9208,
I have a Home 365 Subscription.
I was able to practice along with the Expert.
@@ankursharma6157 I have Office 365, version Microsoft 365 MSO (versión 2403 compilación 16.0.17425.20236) 64 bits, and I don't have this feature yet and no updates available.
@@Computergaga Four months!!