excel 2016 new query

  1. X

    Getting previous 10 workdays (excluding weekends) from Today (vba)

    I am working on a sheet which requires previous 10 working days from today: Something like this: <tbody> 10-Dec 11-Dec 12-Dec 13-Dec 14-Dec 17-Dec 18-Dec 19-Dec 20-Dec 21-Dec </tbody> i am scratching my head from last 3 days with all kind of wiered loops but nothing is working. Can anyone...
    • xs4amit
    • Thread
    • days excel 2016 new query previous vba & excel working
    • Replies: 4
    • Forum: Excel Questions
  2. M

    Dynamic Query

    I’ve been trying to find a way to change location and date from import web page and wondered if somebody could help please? http://www.realtimetrains.co.uk/search/advanced/RAM/2018/09/26/0000-2359?stp=WVS&show=all&order=wtt The two areas are highlighted in bold and “RAM” I was going to use a...
    • mikey141
    • Thread
    • dynamic dynamic query excel 2016 excel 2016 new query
    • Replies: 6
    • Forum: Power Tools
  3. P

    Question-> Excel 2016 New Query -> From Other Sources -> From Web

    Hello, Using Excel 2016 New Query -> From Other Sources -> From Web -> Stock Quote FF FutureFuel Corp. -> Table 0-> 12 rows loaded. The data comes in beautifully, but the problem is it all shows as "Text" data type, so when I pull in the data to a separate sheet using a simple vlookup, then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top