Answer the question
In order to leave comments, you need to log in
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
Just import the maximum possible range, preferably the whole sheet, and work with it.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question