Basics#27. Filter #3. Last non-empty row

[@93gbz]

I was searching this "last empty field of a row" for so long, and you solved it with such a simplicity and elegance. Thanks, I've subscribed and upvoted, I'll watch all your videos.

[@divinorodriguesdasilva5048]

It would be interesting to publish a video with the filter using apps script google sheets using a macro button...

[@davidtopp1972]

Is there a way to utilize your formula by adding to it to do the following: I have created a google sheets checkbook register with 2 tabs + a Dashboard. I would like to be able to have a running balance of both accounts(one in each tab), and have it displayed in my dashboard. I would appreciate it if you would answer this question and send me the framework of the formula. I could send you a sample of the checkbook register if you need it. Thank you!

[@walterpaiva719]

Good quick tips, watching them all

[@mahadevijakkula5762]

hi sir, i am new to sheets vba, i am trying to copy some text from sheet1!A1 to sheet4! column A, but i want to copy every 15 minutes interval to sheet4 in to column A in empty cell. can pls help me in this issue.

[@cooltables]

Hello and thank you for the question! I'm just making new videos on script automation. I'm trying to cover some topics: creating sheets, folders, reports. Your task is copying ranges with a script. This task is common and I plan to create the script and share it in the future video. To solve the task, you'll need to: 1. Create a script for copying a range: developers.google.com/apps-script/reference/spreadsheet/range 2. Create a trigger to run it each 15 minutes: developers.google.com/apps-script/guides/triggers/installable

[@TheBitcoinBattery]

Great video, I'm learning Google sheets and I'm trying to find a way to count the number of full cells in column A since the last full cell in column B, is there a formula for this?

[@cooltables]

Hi, Please try: =FILTER(A:A,ROW(A:A)

[@EPSTomcat11]

Is there a way to return the last non-empty / non-zero value in a column? There's a way in Excel but no one has the solution in Google Sheets 😔

[@doconomist]

=FILTER(A:A;ROW(A:A)=MAX(FILTER(ROW(A:A);A:A"")))

[@samblasvr7114]

Not working anymore, obviously?

[@doconomist]

Works in my environment. Please try: docs.google.com/spreadsheets/d/17JGoduqMU6A2OCRpFe5o_ll4K57ZfCRIsDV7hz3Y7WM/copy

[@LEV1ATHYN]

Are you Guccifer?

[@93gbz]

Is this a mix of Google with Lucifer? Yes I think he is, because I was searching this "last empty field of a row" for so long, and he solved it with such a simplicity and elegance.