igoogledrive.blogspot.com
iGoogleDrive: Creating an IF ELSEIF functoin for Google Spreadsheet
http://igoogledrive.blogspot.com/2012/08/creating-if-elseif-functoin-for-google.html
All Functions and Formulas. Wednesday, August 22, 2012. Creating an IF ELSEIF functoin for Google Spreadsheet. Creating an IF ELSEIF functoin for Google Spreadsheet. So, if I select the number 3 from the Data Validation in cell A1, then B1 displays the number 30%. 2 returns 20%, 1 returns 10% and so on. You have to put the following formula in cell B1 (of "MAIN" sheet):. You can also put the following formula in Cell B1 (of "MAIN" sheet) to get your result:. Following is the screenshot of "MAIN" sheet.
igoogledrive.blogspot.com
iGoogleDrive: GOOGLE SPREADSHEET SCRIPT TO CHECK THE DUPLICATE ENTRIES IN THE SHEET
http://igoogledrive.blogspot.com/2012/10/google-spreadsheet-script-to-check.html
All Functions and Formulas. Friday, October 5, 2012. GOOGLE SPREADSHEET SCRIPT TO CHECK THE DUPLICATE ENTRIES IN THE SHEET. I have updated the script so that you can easily change the range, so now it can work to check duplicates in any column or any row or any range. And it is much more optimized:. Copy the following script in the "Script editor":. Var sheet = SpreadsheetApp.getActiveSpreadsheet();. Var entries = [{name : "Check Duplicates",functionName : "checkDuplicates"}];. Http:/ igoogledrive.bl...
igoogledrive.blogspot.com
iGoogleDrive: How to write a script in Google Spreadsheet
http://igoogledrive.blogspot.com/2012/08/how-to-write-script-in-google.html
All Functions and Formulas. Wednesday, August 29, 2012. How to write a script in Google Spreadsheet. If you are new to Google Spreadsheets and you have never written a script before or if you don't know anything about it, then this tutorial will help you to know how you can write a script in a Google Spreadsheet. Step 1) Open Script Editor:. From "Tools" menu, click on "Script editor.". Look at the following screenshot:. This will navigate to you to the Script Editor. Have a look at the screenshot below:.
igoogledrive.blogspot.com
iGoogleDrive: Google Spreadsheet How to check Duplicates in any Range (any Row or any Column or any Range)
http://igoogledrive.blogspot.com/2013/07/how-to-check-duplicates-in-any-range.html
All Functions and Formulas. Thursday, July 18, 2013. Google Spreadsheet How to check Duplicates in any Range (any Row or any Column or any Range). Following is the Script to check duplicates in any range (that is any column like "A:A" or any row like "1:1" or any other range "B2:G43":. Var sheet = SpreadsheetApp.getActiveSpreadsheet();. Var entries = [{name : "Check Duplicates",functionName : "checkDuplicates"}];. SheetaddMenu("Scripts", entries);. Var sheet = SpreadsheetApp.getActiveSheet();. And If you...
igoogledrive.blogspot.com
iGoogleDrive: Google Spreadsheet Multi Sub Drop Down List
http://igoogledrive.blogspot.com/2013/07/google-spreadsheet-multi-sub-drop-down.html
All Functions and Formulas. Wednesday, July 3, 2013. Google Spreadsheet Multi Sub Drop Down List. Hi I, want to create a dropdown list in google drive excel. The normal list is not a problem, but i have second dropdown that depends on the choice of the first dropdown list. I have a list of several items:. The first dropdown will show me the choice meat / liquid. And if i choose meat i want in the second dropdown the list with horse, dog, chicken ,cow. How is this possible in google drive? And now is the ...
igoogledrive.blogspot.com
iGoogleDrive: Send a Google Spreadsheet sheet to an email address daily by setting a trigger
http://igoogledrive.blogspot.com/2012/08/send-google-spreadsheet-sheet-to-email.html
All Functions and Formulas. Sunday, August 19, 2012. Send a Google Spreadsheet sheet to an email address daily by setting a trigger. Send a Google Spreadsheet sheet to an email address weekly or daily or hourly or minutely by setting a timer trigger. You must have been wondering about whether " Is there a way to send a Google Spreadsheet sheet to an email address daily and that too by a script" If yes then how? So, here is the script:. Var ss = SpreadsheetApp.getActiveSpreadsheet();. Var url = "https:/ s...
igoogledrive.blogspot.com
iGoogleDrive: Google Spreadsheet Compare between software version numbers
http://igoogledrive.blogspot.com/2013/10/compare-between-software-version-numbers.html
All Functions and Formulas. Friday, October 4, 2013. Google Spreadsheet Compare between software version numbers. I need to compare between several version numbers with unusual decemas for integer values like 4.0.4 and 4.3.0. And also to be able to filter and display only the greatest or lowest version. MIN/MAX doesn't see it as numbers, and doesn't work for me. I need help with a filtering and comparison between numbers as 3.2.5 2.4.3 2.2.6 etc. I hope I wrote it's right. Note: I have updated the script...
igoogledrive.blogspot.com
iGoogleDrive: Google Spreadsheet How to stack different columns using a formula or query.
http://igoogledrive.blogspot.com/2013/10/how-to-stack-different-columns-using.html
All Functions and Formulas. Saturday, October 26, 2013. Google Spreadsheet How to stack different columns using a formula or query. Using Mac 10.8.5, Chrome or Safari. I would like to be able to create a sheet pulling the information from the form, and placing the appropriate answers of the other member of the family underneath the first response, keeping the blanks if any, to match the names. The sample worksheet is here with the expected results:. You will need to install script VMerge. AF:AF=" ) ) ) ).
igoogledrive.blogspot.com
iGoogleDrive: All Functions & Formulas
http://igoogledrive.blogspot.com/p/all-functions-formulas.html
All Functions and Formulas. All Functions and Formulas. Mark D. Henderson, CFA. October 20, 2014 at 9:14 PM. Nicely done. I like the layout. The strikethrough answer got me here. Subscribe to: Posts (Atom). GOOGLE SPREADSHEET SCRIPT TO CHECK THE DUPLICATE ENTRIES IN THE SHEET. Note: I have updated the script so that you can easily change the range, so now it can work to check duplicates in any column or any row. Creating an IF ELSEIF functoin for Google Spreadsheet. Following is the Script to check dupli...
igoogledrive.blogspot.com
iGoogleDrive: Google Spreadsheet ImportHtml auto update or refresh
http://igoogledrive.blogspot.com/2012/09/google-spreadsheet-importhtml-auto-update-or-refresh.html
All Functions and Formulas. Tuesday, September 18, 2012. Google Spreadsheet ImportHtml auto update or refresh. I'm using the =ImportHtml function to get some data from an HTML table. It works okay, but I need it to refresh. The HTML data will change periodically, so I need the spreadsheet to periodically check to see if the data have been updated. Right now it seems to be pretty static, and I can't find a setting or anything to make it check for new data. Then change it to:. Minute(now() ,"table",4).
