How do you highlight duplicates in a defined range using conditional formatting in Google Sheets? To highlight cells that are the same value in a range, select the range and use a custom formula in the conditional formatting area that uses relative referencing. The custom formula you will want to insert into the conditional formatting area is: = C O U N T I F ( r a n g e , I N D I R E C T ( " R C " , F A L S E ) ) > 1 Where range is the same highlighted range of the conditional formatting range. ...

How do you download images using Selenium Python? Selenium provides a way to create a screenshot of your browser’s view using the .save_screenshot(file_name) method, but this will take a photo of the viewport – what if you just want to download the image as it is? Unfortunately, Selenium doesn’t have the capability of selecting menu items in your browser window, therefore you will need to install a library that can help select menu items to the browser. ...

How can you extract a date from a string in a cell in Google Sheets using the powerful REGEXEXTRACT() function? The REGEXEXTRACT(text, regular_expression) function has two parameters with the first labelled as text being the string operated on and the second labelled as regular_expression being the regular expression (using RE2 syntax) to extract data from. Here are a few popular examples of how you can use this powerful function to extract dates from a string in Google Sheets. ...

How do you download a PDF file when the URL opens up a PDF in your Chrome browser in Python without needing to print the page or use special key presses? And how can you set the location of the PDF? The trick to be able to download a PDF file using Selenium without the Chrome browser opening the PDF file within the browser window is to set the preferences of the browser to simply not open PDF’s automatically. ...

How can you highlight an entire row based on a single condition in another column? To highlight an entire row based on a value in a column using conditional formatting requires using the INDIRECT() formula. A spreadsheet contains the following simple data where the first column contains a list of dates and the other columns contain corresponding data for that date. Here’s a snapshot of the spreadsheet which contains Date, Bank Pmt Id and Interest Rate: ...

How do you sort a list of tuples by the first element in each tuple in Python? To sort a list of tuples in Python use the .sort() list method if you want to modify the list to sort or the sorted() function if you want to generate a new list. Use the parameter key with either function and set the value of that parameter to a lambda expression that returns the required tuple you want to sort by. ...

What does AttributeError: module 'datetime' has no attribute 'strptime'mean and how can you easily fix it? When parsing a string and transforming that to a date you can make use of the function strptime in the datetime module. To use this function simply import datetime as you normally would with any module, and use the function as follows: 1 2 3 >>> import datetime >>> datetime.datetime.strptime("16/06/22", "%d/%m/%y") datetime.datetime(2022, 6, 16, 0, 0) Notice in the above code that the function strptime is found within the module datetime and class datetime, therefore, if your code just has import datetime at the top you will need to enter the module and class followed by the function. ...

What does $A$1 mean in a spreadsheet formula in Excel or Google Sheets? The syntax $A$1 is simply an absolute reference to cell A1. The reason why there are dollar signs prefixed in front of the column and row labels is to prevent the cell from changing its reference as the original cell is copied to another cell. If a cell containing a reference to A1 is not needed to be copied, or if the reference to cell A1 is not needed to be fixed when copied elsewhere, then the dollar signs are not required. ...

How do you use absolute cell references in a spreadsheet like Excel or Google Sheets? An absolute cell reference is a reference containing the common column letter and row number labels but around those labels are either one or two dollar signs. For example, the following references for cell A1 are all absolute references: $A$1, $A1 and A$1. What’s the difference between each of three references? The purpose of the dollar sign in front of the column label and/or the row label is that this fixes the column or label. This helps when copying a cell and you want the reference of the column or row or cell to remain static. ...

How do delete an attached Google App Script file and project from a Google Sheet? I recently wanted to copy a Google Sheet and as I did I noticed it had an attached Google App Script file. Here’s what that dialog window displayed: However, I didn’t want the adjoining scripts with the copy, in fact I wanted to delete all the original scripts from the original spreadsheet as these were no longer needed. ...