Posts

How many ways can you underline in Google Sheets? There are three broad approaches when seeking to emphasise text in Google Sheets by applying underlines. These three approaches are: underlying specific or whole text in the cell, underlying the whole cell itself with different styles, or using underscore characters. Here is each approach with examples below: Underline Specific Text The most common approach to underlying text in a cell in Google Sheets is to use the keyboard shortcut Cmd + U (or Ctrl + U for Windows). If you have selected text within the formula bar and apply this keyboard shortcut while having text highlighted, it will underline just the selected text as shown here: ...

How can you create a unique ID with date values in Google Sheets? To create a unique ID of date values in Google Sheets use the TEXT() function to change the date into a string and then append any other useful identifier to that string to make the value unique, such as ROW() or a counter such as COUNTIFS(). Creating a unique ID for your data rows can help speed up the processing of your data, for example when using the VLOOKUP formula. If you can create a column with unique ID’s you could then make the fourth paramter of the VLOOKUP function TRUE which speeds up processing time. ...

How do you fix Google Sheets when it is running slow? The five ways to speed up working in Google Sheets when it is running slow are: filter your data when working on specific rows, convert formulas to values where possible, sort your data if you are working with functions like VLOOKUP, create a unique column ID to help find data quicker, and look at alternative functions instead of VLOOKUP. ...

How do you create a file name with an incrementing number in Python? To create an incrementing file name in Python, run a while loop that checks the existence of a file, and if it exists, use Regex to modify the file name by replacing the integer at the end of the file with the next number. Continue looping until the file name does not exist in the destination folder. ...

How do you format time to be in 24-hours using Python? In Python you can format a datetime object to be displayed in 24-hour time using the format %H:%M. This is not to be confused with the 12-hour time which uses the format %I:%M and may have %p appended to the end to denote AM/PM. Here’s an example demonstrating the conversion of time from 12-hour format to a 24-hour format: ...

How do you apply logical conditions to get multiple elements, very specific elements, or even exclude elements using XPath? XPath syntax does enable the use of logical operators and, or and not() when searching for elements within your HTML or XML document. To use the logical and and or conditions on obtaining certain elements wrap your syntax in square brackets with a prefixed asterisk. For example, I recently needed to obtain all the tr tags in a data table and only wanted the tr tags if they were nested within a thead or tbody (not a tfoot tag). Therefore, my syntax looked something like this: ...

How do you format a string in the format of HH:MM AM/PM to 24-hour time in Python? To change a string in the format HH:MM AM/PM to 24-hour time in Python use the datetime.datetime.strptime(original_string, format_string) function located in the datetime library. As the datetime class needs to be imported from the datetime library you need to make sure you include the reference twice, otherwise you may get strptime AttributeError errors. Here’s an example of how this works: ...

How do you convert a string in the format of DD/MM/YY to a date in Python? To convert a string in the format of DD/MM/YY to a date in Python import the datetime library and use the datetime.datetime.strptime(date_string, format_string) function (yes, that is not a typo the datetime library has a datetime class and it contains the strptime function). To make it easier to access the strptime() function it helps to import the datetime class when the datetime library is imported, like so: from datetime import datetime. ...

How can you wrap text in a cell in Google Sheets? There are 3 ways you can wrap text in a cell in Google Sheets. The most popular method is to click on the Google Sheets wrap icon, whereas the two other two methods are more manual and require you to enter the line break for the cell – of the two manual methods, one is a keyboard shortcut, and the other is a function. ...

How can you alphabetize or sort your data in Google Sheets? There are 5 ways to alphabetize data in Google Sheets: two approaches involve using formulas; namely, the SORT() and QUERY() functions, and the other three approaches involve using the menu items located in the menu bar. All approaches require knowing if the sorting will be done in ascending order, where your data starts from those cells closest to A and ends with cells closest to Z, or in descending order which does the opposite. ...