This is great. I hope you could upload a video as well about inserting blank rows automatically after every change of data.
@GospelMusicians
3 жыл бұрын
THANKS!
@tecnoideas7436
4 жыл бұрын
Hi! Writing from Paraguay. Your channel is gold. I can't say enough how you already helped me. My best wishes to you and your work
@ExcelGoogleSheets
4 жыл бұрын
Awesome! Thank you!
@lauraa.3593
4 жыл бұрын
Thank you! If may I suggest a topic... have you thought about creating a series of videos about a request workflow with multiple levels of authorization? I can imagine that it will involve: google forms, sheets, apps script, and gmail.
@yuttanak6225
4 жыл бұрын
thank you so much and many of your tutorial videos have helped many people including me you are amazing
@ExcelGoogleSheets
4 жыл бұрын
Happy to hear that!
@carmencastro5512
4 жыл бұрын
Thank you for this video teacher!!!
@pageuplab
Жыл бұрын
Sorted Thanks for the Effort
@ronaldjohnson_ita
4 жыл бұрын
Good stuff as always. I was wondering is there a way that if a cell says, “Approved” (C2) that it adds a data validation to reject input from the user (A2:C2). I want to make an request sheet system where I can approve requests. The user makes requests by entering in date and vacation and I approve. Once I approve it, they can’t modify it. Thanks!
@findthetruth3021
4 жыл бұрын
I have created a from recently by visual studio code, but I have only a single problem. I can't make a reset function when the form is going to be submitted. Which means the filled gaps will remain with the same information without being reset. I would love to share with you my whole code, just add this function to there. Waiting for your kind response. Thanks in advance.
@Mikarevival
4 жыл бұрын
Great Job!!!
@findthetruth3021
4 жыл бұрын
Is it possible to create a drop-down and enable multiple selections in Google Sheets?
@atharmuslim
Жыл бұрын
just a big WOW!
@marykmendes6404
3 жыл бұрын
Could anyone please let me know what to type into the filter column. What is the entire function that I need to type in
@leobae9294
4 жыл бұрын
I’m looking for videos that can help me :) if i try to explain what i’m doing it simply, i would say that i’m studying 100 sentences that i want to memorise and they are not in numerical order. If i studied sentence 5 i want to put 1 in A5 and if i studied sentence 60 i want to put 1 in A60. “1” means i practised once. I want to see sentences i haven’t practised yet or the least times to study them for the first time. I don’t want to spend too much time for the same sentences. Which video should I watch?? ( plus, if there are so many sentences then i would need to scroll all the way down to put “1”. : Sentence 1000 => A1000)
@francobobatto6995
4 жыл бұрын
you can do that with "iteration calculation" enabled, search for "iteration calculation" video from this channel. Then you could put a checkbox column on what sentence you have read once so with an if statement activate the iterative counter. You would probably need to use an array of validation of the other checkboxes so you wont sum 1 on all of them everytime you read one sentence. Finally you could filter them out by the number of times read or do a query with "x column is > x number". Something around that idea might work for you
@lostmamo433
4 жыл бұрын
Can you do a Google query to only select and show rows where there are no blanks (on another tab) as an alternative solution?
@ExcelGoogleSheets
4 жыл бұрын
Watch my QUERY function videos.
@findthetruth3021
4 жыл бұрын
You are amazing bro. Always making great videos.But, I have a suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
@ExcelGoogleSheets
4 жыл бұрын
Watch my dashboard videos.
@findthetruth3021
4 жыл бұрын
@@ExcelGoogleSheets you are the best.
@cric8482
4 жыл бұрын
Use Query
@GazeKuNG
2 жыл бұрын
How can I subtitute text "AA" from "AABC" in column A?
@GazeKuNG
2 жыл бұрын
in macro,sorry
@anaklokal5530
2 жыл бұрын
i was try but it said "Exception: Those rows are out of bounds." what can i do to fix it?
@ebx2323
3 жыл бұрын
Does anyone know how to keep the date data from coming over as a number value when you use concatenate? IE. date 08/12/2021 converts to 44420 using concatenate.
@ExcelGoogleSheets
3 жыл бұрын
=concatenate(TEXT(A1,"mm/dd/yyyy"),B1)
@LeoCRoderick
3 жыл бұрын
thank you so much! amazing!
@cric8482
4 жыл бұрын
Hi, Nice idea but only works if there are less than 8 columns in the table. If there are more columns, the macro will delete some data.
@ExcelGoogleSheets
4 жыл бұрын
Couldn't you just record it for more columns?
@cric8482
4 жыл бұрын
@@ExcelGoogleSheets Yes of course but I'll try to write a code to find the last column with data in the first row in order to avoid any problem
@ExcelGoogleSheets
4 жыл бұрын
@@cric8482 Another approach could be adding a column to the left of your data for concatenate function, use open column reference in concatenate function B2:2 and then deleting it after the cleaning. This way it won't get on the way.
@cric8482
4 жыл бұрын
@@ExcelGoogleSheets Clever ! thanks
@cric8482
4 жыл бұрын
@@ExcelGoogleSheets The code with insert 1 column : /** @OnlyCurrentDoc */ function ElimVide() { // Delete Empty Rows (Blank Rows) in active sheet kzitem.info/news/bejne/r3qVmYdve6aAiII from Learn Google Spreadsheets var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A:A').activate(); spreadsheet.getActiveSheet().insertColumnsBefore(spreadsheet.getActiveRange().getColumn(), 1); spreadsheet.getActiveRange().offset(0, 0, spreadsheet.getActiveRange().getNumRows(), 1).activate(); spreadsheet.getRange('A1').activate(); spreadsheet.getCurrentCell().setValue('filter'); spreadsheet.getRange('A2').activate(); spreadsheet.getCurrentCell().setFormula('=CONCATENATE(B2:2)'); var currentCell = spreadsheet.getCurrentCell(); spreadsheet.getSelection().getNextDataRange(SpreadsheetApp.Direction.DOWN).activate(); currentCell.activateAsCurrentCell(); spreadsheet.getRange('A2').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false); spreadsheet.getRange('A:A').activate(); spreadsheet.getRange('A:A').createFilter(); spreadsheet.getRange('A1').activate(); var criteria = SpreadsheetApp.newFilterCriteria() .whenCellEmpty() .build(); spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(1, criteria); spreadsheet.getActiveSheet().deleteRows(2, spreadsheet.getLastRow()-1); spreadsheet.getRange('A:A').activate(); spreadsheet.getActiveSheet().deleteColumns(spreadsheet.getActiveRange().getColumn(), spreadsheet.getActiveRange().getNumColumns()); spreadsheet.getRange('A1').activate(); };
@Shankar_Nishant
3 жыл бұрын
thanks
@pichit.raetai
4 жыл бұрын
Love
@ВолодимирКоробка-п5р
4 жыл бұрын
Ah, it's so hard for me to understand how to work with ranges and selection in JavaScript instead of VBA(( There is so many small scripts i have written in excel that don't know how to reuse in sheets
@ExcelGoogleSheets
4 жыл бұрын
I don't see that much difference. Of course you can't just copy your VBA code, you have to completely rewrite it.
Пікірлер: 40