A
A
Alpha122019-01-26 22:46:20
Google Sheets
Alpha12, 2019-01-26 22:46:20

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

1 answer(s)
A
Alexander Ivanov, 2019-01-26
@oshliaer

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]"
)

Working example https://docs.google.com/spreadsheets/d/1FH3QTXRRKH...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question