OFFSET Function - Google Sheets

Learn how to use OFFSET function in Google Sheets.
Invoice Video: • Google Sheets - Invoic...
#offset #function

[@tedchmura]

Sir, I just hope you're making a LOT of money because you simply are the BEST teacher/explainer on this stuff. Always thorough, logical, and easy to understand. Bravo! And thank you.

[@diegomouratorres7094]

Without a doubt, this is the best channel on Google Sheets. You're doing a terrific job with easy-to-grasp explanations and insightful approaches on data analysis. Every time I watch one of your videos, I find novel ways of solving everyday problems with spreadsheets. This one was a good example of that. I found it extremely useful the custom number format trick you showed and the method to get the range whose the "height" is equal to a value specified on a cell and that comprises the latest values. Thank you so much!

[@chandra71566]

,, , _,

[@cric8482]

That's crazy !. I've been looking why offset formula was not working with arrayformula, and here I see it's OK ! Wonderful !!!

[@anvi84]

Enjoyed learning the custom number format trick. It is pretty awesome.

[@Egraedol]

Just found out this function existed from a Excel video but needed to figure out how to do it on sheets, so I came here. Happy this video told me what I needed, didn't dilly dally, and didn't just give me BS as I had to average every 10 cells from a list of 1000 cells of values (for PSMT). Originally I was doing that manually but thought that there had to be someone else who had been in the same situation as me and had found a way to make it efficient, and I was thankfully correct. Anyhoo, back to that assignment, thanks!

[@lazalazarevic6192]

Thank you for another amazing lesson.

[@johnnymobaanjiai8955]

ampun bang jangan ilangin komen gua, gua cuman mau bilang keren bat lu asyu !!!

[@Puner54]

Wow! How did I miss this Fantastic Video!?!?

[@ummemarzinajotey2901]

Thank you sooo much... U r my KPI Saver.

[@heavyferrum397]

OH MY GOD! you just solved a problem i had for SOOOOO long! THANKS!

[@lauraa2644]

Excellent! Thank you!

[@paulagarland9288]

Good stuff, thanks!

[@bikeman9899]

This is excellent!

[@antonarap5393]

Is there a way to visualize the range Offset selects? I used to do that with GoTo in Excel but in Gsheets the Goto dialogue apparently it doesn't accept formulae

[@rajsahu1029]

Very Nice

[@ExcelGoogleSheets]

Thanks!

[@johnnybravo2268]

What is the formula in the Line (B column) in the invoice template? It automatically adds and updates the line number when modified

[@physical-therapy]

For the COUNTA + COUNTBLANK part, can't it be just ROWS(B:B) ?

[@ExcelGoogleSheets]

Yes! That would have been better.

[@haodphung]

This is very an inspired tutorial, I always learn from your video. If i have a dynamic products list, which lookup from another sheet, let's say using query function to query all the products on the invoice for instead, how could it add the grand total underneath the total price. Is there any function to do that or need to utilize Javascript. Thank you!

[@ExcelGoogleSheets]

Yes, you need to use arrays.

[@emilianoreyes]

Thank you!

[@MonicaArpia]

Hello, I have a data set where I delete the first row entry and add in new info on the next blank row. I noticed that this breaks the formula into an error. Is there any solution to this except not to delete the first row entry? Thank you!

[@72NeverFold]

Nice video! Thank you. From where did you get the calender on 14:40?

[@72NeverFold]

@T R A D E M I L L Doesn't work for me

[@72NeverFold]

@T R A D E M I L L I got it, double-click to open a calendar. Cool, thanks!

[@maxvick]

I have 5 task assigned for the week. Each task each day of the week. On Monday my task is not completing so I want to change it's date to tuesday and I want all the dates to offset as per one day and last date automatically moves to next Monday. How should I automate this?

[@AbhishekSharma-gn4iu]

what if i want to start multiplying $10 (AS BONUS) FROM CELL B5 DOWNWARDS , SHOULD GET UPDATED IN SAME COL B. IM USING ARRAY FUNCTION IN B1

[@ExcelGoogleSheets]

You can't update the same values in the same location with a formula.

[@AbhishekSharma-gn4iu]

@@ExcelGoogleSheets thankyou

[@charudhingra3062]

I want to sort my sheet by row wise if I enter value and if it is smaller than above one whole row comes down Is there a way?

[@ExcelGoogleSheets]

Maybe this? kzbin.info/www/bejne/aXa4epKGnN2UqKM

[@keuangangunacitralestari4946]

Why offset formula can't work on data validation drop down list?

[@cuneiformscript2665]

🙏🏻

[@JeanMalissard]

Another solution at 17:35 =SUM ( INDEX(B2:B,COUNTA(B2:B)-E1):INDEX(B2:B,COUNTA(B2:B)) )

[@byrmn__]

Hi Sir! Please make a video about SEQUENCE function, I'm trying to understand how "=MAP(A2:INDEX(A:A,COUNTA(A:A)),LAMBDA(a, ARRAYFORMULA(JOIN(" - ",TEXT(EOMONTH(a,SEQUENCE(DATEDIF(a,EOMONTH(OFFSET(a,0,1),),"M")+1)-1),"mmm")))))" that i got from stackoverflow, so it would be great if you make a video about it. thank you.

[@ExcelGoogleSheets]

The hard parts here are lambda and map functions and I have videos on the channel covering both of those. That's where I would start.

[@saisrinivasavvaru1218]

How can I create a custom print function with a predefined format for a given sheet using app scripts? How to use the Class blob to achieve the custom print function?

[@m.s.d2656]

GOOGLE SCRIPT: Where does this script execute ? Is this uses any google server ? If yes , then what kind of server . Is it provide cpu to process these script ? If No, then without cpu how could any script execute. 🤯 How is it different from google colab. ? I’m confused 😭😭