Forum

Mohamed, This is the 3rd time I have asked you to attach a workbook. Without your actual file/query/data I can not help. Phil

Aye, Please always supply a workbook with data You haven't said how you are sorting but I'm guessing it's by the AccomCode. When I type those c...

Yes that's fine, please provide an example of the xlsx file and what you want as a result. Regards Phil

Hi, Please provide a workbook containing your data and example(s) of the expected result. Phil

Hi Sholtan, As I've asked you on other posts, please supply the workbook(s). Impossible to do anything without the data this code operates with. ...

Hi Robert, The {} means it's an array formula. Excel Array Formulae I'd say the forumla(e) is(are) referencing some cells that result in #VAL...

Hi maccra, That website provides an API so you may be able to use that to get the data you need. It says that they provide tools to access th...

The problem here is the site you are accessing so anything we try is a workaround. You may need to use VBA to scrape the data. Web Scraping with V...

Hi Rebekka, How about using conditional formatting to highlight the lowest price for each part, the use some MIN functions to pull out the lowest p...

Hi Alan, Please., always supply a workbook so we don't have to recreate (incorrectly) your data, and so we can see what you are actually working wi...

No worries Scotty, glad you figured out a solution. Regards Phil

Hi Maccra, I tried it and it worked for me. I'm using W10 and IE11. If I start IE and accept the T&C's I can then browse the site using PQ....

Hi Scotty, If you Merge Columns in the PQ Editor you can do this. Click on the 2 column headers that you want to merge, then right click one of ...

No worries 🙂

You're welcome 🙂