Nice video sir!! I appreciate your work and i am waiting for next video of tables 😀😀😀
@frikosimon2 ай бұрын
Perfect vid
@taufiqurrahman5949 Жыл бұрын
best tricks
@emilianoreyes4 жыл бұрын
Thank you!
@srider334 жыл бұрын
Man... do you ever sleep?!? Tables are a great gem. GoogleSheets needs to figure out how to compete with this.
@aleborissa4 жыл бұрын
I have some sheets with lots of cells using importrange function. My problem is that each sheet have different information and if my first sheet which has names changes, the names on the other sheets will change and I will lose the information corresponding to each name on the following sheets. For example: my first sheet has a column with the names and some personal information for BOB, ADAM, DAVID, CLARK. Now my second sheet brought those names in in that same order and the second sheet will then have grades for each one of them: BOB 10, ADAM 9, DAVID, 5 and CLARK 8. Now, lets say, I decide to put the first sheet in alphabetical order: ADAM, BOB, CLARK, DAVID. And that's where my problem is, because now in the second sheet ADAM has 10 points, BOB has 9, CLARK has 5 and DAVID has 8. How can I make the following cells change automatically with the first cell when using importrange?
@ExcelGoogleSheets4 жыл бұрын
There are too many issues here, and you probably shouldn't be using IMPORTRANGE for names if you are planning to modify them. It seems to me like you need to be using VLOOKUP with IMPORTRANGE to match relevant information, instead of just doing IMPORTRANGE.
@scalpingstar1992 Жыл бұрын
Dear Same thing is possible in google sheet ????? Pls ans ??