L
L
luckyness2020-06-09 17:47:52
Google Sheets
luckyness, 2020-06-09 17:47:52

How to reduce the number of importrange?

Good time!

I need help, please tell me how to correctly implement calculations in order to minimize the use of heavy functions, in particular IMPORTRANGE

An example of what it is about https ://docs.google.com/spreadsheets/d/1w45k1YqrHH...

Sheet2" in cell A2, I determine the number of unique records by importing data (since the data is in another table in reality, but here, just for example, I transferred it to the same table).
Then in column B I summarize the values ​​for each entry by importing the data.
I suspect that this can be shortened and not duplicated with import formulas, but I don’t understand how to do this. And I would not want to create intermediate sheets either. Please help!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-06-09
@oshliaer

Just import the maximum possible range, preferably the whole sheet, and work with it.
5edfa39590c6c693048713.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question