Last seen: Jun 8, 2026
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 🙂
Hi, Between your 2 posts there just over 90 minutes elapsed. Have some patience, you're not paying for this service, and we all have jobs. It's...