How to change prices from 7days avg to best offert
Hi everyone, I'm creating this post for those who want to get the price of the lowest first offer instead of the average price. To do this, you need to replace the line: =IMPORTXML(E7; "//*[@id='tabContent-info']/div/div[1]/div/div[2]/dl/dd[10]/span") with this: =IMPORTXML(E9; "//section[@id='table']/div[@class='table article-table table-striped']/div[@class='table-body']/div[1]/div[@class='col-offer col-auto']//span[@class='color-primary small text-end text-nowrap fw-bold ']") The /div[1] parameter indicates which row to select, so if you don't want to get the first price for any reason, you can change it to the row number you prefer. :)