Somebody left in my company, and I'm in charge to deliver information for 750 dayli records from the web, this totally simplified my work, just what I was looking for, thank you very much
Hi Bill in real time scenarios it will ask for a sign in page before opening any office portal. can you help me how we can do web scrapping in that cases.
This is great, is there a way to combine 2 different queries into one table? For example there are 2 separate tables on each page that i want to extract data from. i Have been able to suceed using you method to get 1 table extracted over multple pages. (is there a way to join the second table?
Hi Bill, What if the last page is not known....how can i dynamically define the last page. Kindly help me with your inputs. Amazing video bill :) Thanks and Regards Kishore
Thanks for this its fantastic just subscribed. one question, It works perfect when the table header of the original query is exactly the same as the new table in the different URL. My problem is the example I'm trying to do, the second URL sometimes changes the headers slightly depending on the site. Therefore when i run the query it comes up with the "[Expression.Error] The column 'xxxxxx' of the table wasn't found". I was wondering if there was was a way to have Power query search for a second header if there is an error on the first. It would be great if you could do a vid on this thanks
This is very powerful. However I sometimes get a Power Query error "Operation is not valid due to the state of the object" (for whatever that's worth!)
Thanks great video as always -- have you done any examples with "Scraping" data from Website that are note using tables? Cam you still use M / Power Query or do you have to use R-Script or similar?
Hi, Professor, you have provided a lot of effort for these videos, thank you, I have a question in excel, if we have for example in cell "a1" the number 10.00 m, how to have this number in the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍
I am going to ask you two important questions: 1) Go to cell B1. Type a formula of =A1 and press Enter. What do you get in B1? Are you getting something like 10? Can you try this: Copy A1. Select B1. Right-click B1. In the row of paste options, choose the 5th item (Formats). Does that correct the problem? 2) With cell A1 visible, press Ctrl and the grave accent (`). What do you see in A1 now? Press Ctrl+` to go back to the normal display.
Good morning, when we use the search functions in Excel, we do not get the cell formatting that we are looking for. I want to get the full cell format. Is that possible? I thank you for all the efforts you are making through these videos, thank you so much.😃👍
@@mohamedadjal8502 Please watch this video: th-cam.com/video/h1xM8A_4v8U/w-d-xo.html As you can see, it is working for me. Let me know what part of this scenario is different for you.
Good evening Professor, I thank you for the answers that you sent me on the Internet. May God protect you. Suppose we have in cell a1 = "excel", in cell a2 = "is", in cell a3 = "fun", in cell b1 = 12.00m, in cell b2 = 10.00gr, in cell b3 = 15.00kg, use the vlookup function: vlookup = ("is", $ a $ 1: $ b $ 3,2, false), the result is 10, which means that This function didn't give me the full format of the number in cell b2 (b2 = 10.00gr), but my goal is to get b2 = 10.00gr and not b2 = 10. thank you so much.😃👍
Is your book available in a book store? Amazon is whack if they think I am paying $40+. Amazon ain't no bargain. I want your book but not at $40+. I will buy it for its asking price but their shipping cost is ridiculous.
Thanks for this video. When I follow the instructions you provided for adding the column in Power Query, at 4:06, the resulting column is full of "error" values. When I drill down, I see the following error message: An error occurred in the ‘’ query. Expression.Error: The column 'Temperature (° F)' of the table wasn't found. Details: Temperature (° F) When I initially pulled in the data from the table from Weather Underground, I went to Power Query and removed the Temperature Column, or so I thought. Maybe I renamed it. In any case, I followed the steps exactly for adding the column into the query created from the daily weather data table. I'm not sure what I'm doing wrong.
hello teacher, I watched your videos on TH-cam and wanted to consult you about a difficult issue. We want to dump the websites and e-mail addresses of the brands we found on the internet into Excel. In other words, the company or brand name on the left line, the website and email taken from automatic google right next to it.
As we find new brands, we will add them to the excel file and as the code runs, it will continue to find their website and emails. I would be very grateful if you could help with this, free or paid. Enjoy your work.
![เปิดใจ “ต้นหอม ศกุนตลา” หลังโดนพาดพิงธุรกิจที่เคยทำ และผลกระทบทำถูกปลดฟ้าผ่า! | แฉ 24 ต.ค.67 [2/3]](http://i.ytimg.com/vi/vCi5OIqlxaE/mqdefault.jpg)
Somebody left in my company, and I'm in charge to deliver information for 750 dayli records from the web, this totally simplified my work, just what I was looking for, thank you very much
somebody should be awarded a nobel prize for thinking of this.
In the words of the great Mike "ExcelIsFun" Girvin - "You have GOT to be kidding me!" This was an amazing video - thank you!
Thanks, this was super useful. Thank you.
Thanks for the Power Query Radness!!! $74 bucks, that is a great deal!
Amazing video!! This is what I am looking for
Hi Bill in real time scenarios it will ask for a sign in page before opening any office portal. can you help me how we can do web scrapping in that cases.
I was wondering if power query could do this easier than vba. Now I know! Thanks Bill !
I was doing g the same thing, learning VBA to webscrap, but this is much better
Any chance to scrap data from Vidiq or some sites that require login?
Wow. Thank you.
Thank you. Thank you
Keep putting the good word out.
From FTW, Troy
Thank you Troy Scott.
This is great, is there a way to combine 2 different queries into one table? For example there are 2 separate tables on each page that i want to extract data from. i Have been able to suceed using you method to get 1 table extracted over multple pages. (is there a way to join the second table?
Fantastic !!!!! One question
Why only 15 days ? I am so interested to know how you can work with dynamic months with different max min days
Hi Bill,
What if the last page is not known....how can i dynamically define the last page.
Kindly help me with your inputs.
Amazing video bill :)
Thanks and Regards
Kishore
Please let me know ..how can I attend your seminars?
It is amazing! 🤩🤩🤩🤩🤩🤩🤩🤩
Great explanation Thanks, what if there is a LOG In to the weksite? Take care and thanks again!
If you are using Office 365, there is now a way to specify the authentication method for the call to the website.
absolutely incredible, great video.
Hi, how if the website required user & password?
What about Timeout error after 100 seconds?
Amazing video!! Thanks!
Thanks for this its fantastic just subscribed. one question,
It works perfect when the table header of the original query is exactly the same as the new table in the different URL. My problem is the example I'm trying to do, the second URL sometimes changes the headers slightly depending on the site. Therefore when i run the query it comes up with the "[Expression.Error] The column 'xxxxxx' of the table wasn't found".
I was wondering if there was was a way to have Power query search for a second header if there is an error on the first.
It would be great if you could do a vid on this thanks
This is very powerful. However I sometimes get a Power Query error "Operation is not valid due to the state of the object" (for whatever that's worth!)
Thanks great video as always -- have you done any examples with "Scraping" data from Website that are note using tables? Cam you still use M / Power Query or do you have to use R-Script or similar?
I don't have any videos using R-script. I want to learn R, but I haven't gotten there yet.
So much to do -- so little time :) R-Script seems like it lots of things it can do -- thanks!
Guruji 🙏
Man, you so much helped me! THX YOU
Hi, Professor, you have provided a lot of effort for these videos, thank you, I have a question in excel, if we have for example in cell "a1" the number 10.00 m, how to have this number in the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍
I am going to ask you two important questions:
1) Go to cell B1. Type a formula of =A1 and press Enter. What do you get in B1? Are you getting something like 10? Can you try this: Copy A1. Select B1. Right-click B1. In the row of paste options, choose the 5th item (Formats). Does that correct the problem?
2) With cell A1 visible, press Ctrl and the grave accent (`). What do you see in A1 now? Press Ctrl+` to go back to the normal display.
Good morning, when we use the search functions in Excel, we do not get the
cell formatting that we are looking for.
I want to get the full cell format. Is that possible? I thank you for all the efforts you are making through these videos,
thank you so much.😃👍
@@mohamedadjal8502 Please watch this video: th-cam.com/video/h1xM8A_4v8U/w-d-xo.html
As you can see, it is working for me. Let me know what part of this scenario is different for you.
Good evening Professor, I thank you for the answers that you sent me on the Internet. May God protect you. Suppose we have in cell a1 = "excel", in cell a2 = "is", in cell a3 = "fun", in cell b1 = 12.00m, in cell b2 = 10.00gr, in cell b3 = 15.00kg, use the vlookup function: vlookup = ("is", $ a $ 1: $ b $ 3,2, false), the result is 10, which means that This function didn't give me the full format of the number in cell b2 (b2 = 10.00gr), but my goal is to get b2 = 10.00gr and not b2 = 10. thank you so much.😃👍
Is your book available in a book store? Amazon is whack if they think I am paying $40+. Amazon ain't no bargain. I want your book but not at $40+. I will buy it for its asking price but their shipping cost is ridiculous.
Thanks for this video. When I follow the instructions you provided for adding the column in Power Query, at 4:06, the resulting column is full of "error" values. When I drill down, I see the following error message:
An error occurred in the ‘’ query. Expression.Error: The column 'Temperature (° F)' of the table wasn't found.
Details:
Temperature (° F)
When I initially pulled in the data from the table from Weather Underground, I went to Power Query and removed the Temperature Column, or so I thought. Maybe I renamed it. In any case, I followed the steps exactly for adding the column into the query created from the daily weather data table. I'm not sure what I'm doing wrong.
did you find a solution for this? Im having a similar issue scraping a different webpage.
hello teacher,
I watched your videos on TH-cam and wanted to consult you about a difficult issue.
We want to dump the websites and e-mail addresses of the brands we found on the internet into Excel. In other words, the company or brand name on the left line, the website and email taken from automatic google right next to it.
As we find new brands, we will add them to the excel file and as the code runs, it will continue to find their website and emails.
I would be very grateful if you could help with this, free or paid.
Enjoy your work.