Answer the question
In order to leave comments, you need to log in
How to disable autocomplete fields in google sheets?
Good afternoon, I created a Google table.
Here
I
use the formula =importxml.
Everything works, but for example, if I enter the formula in cell c2, the values will be duplicated in cell c3, how can I turn it off?
Answer the question
In order to leave comments, you need to log in
The formula works correctly - it finds all elements that satisfy the condition. You only need to get the first element of the array. For example, like this
=IMPORTXML(
"http://shop.marlin.com.ua/products/gidrokostyum-marlin-skiff-20-7-mm";
"(//div[@class='mainTool']//p[1]//span[@class='prices'])[1]"
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question