H
H
hazestalker2017-05-09 12:48:45
Google Sheets
hazestalker, 2017-05-09 12:48:45

How to accumulate data in one cell?

According to the formula =mid(importxml(x; y);a;b), values ​​from the site are displayed in the cell.
It is required to add (not replace) data to the cell by automatically running the formula periodically. Data must be provided in the form of a drop-down list, sublist, free table. The time and date of the check should be recorded in adjacent cells.
How to implement?
Google Sheets app or Google Sheets
ba9a16a6e95645eeb34c1e14267e1657.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2017-05-09
@dimonchik2013

1) read into buffer
2) append to buffer
3) write buffer to cell

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question