![]() ![]() ![]() Go to the Extensions menu and select the Apps Script option to open the code editor. Two methods will be discussed in this post, using a helper column, and using the FILTER function.īoth methods will depend on the use of a custom function. Get your copy of the example workbook and follow along to learn how to filter your strikethrough data. While this can be a great visual indicator, it is a poor method for tracking since there are no tools available to filter based on this format.Īny further analysis based on the strikethrough format is nearly impossible! Fortunately, this tutorial will show how with two easy methods that will make filtering strikethrough a breeze. Often times people will use the strikethrough format to indicate an item in their task list has been completed. Do you need to filter your data based on a strikethrough format? This post is going to show you how you can filter the strikethrough items of your list in Google Sheets. Google Sheets offers several ways to automatically highlight the text you want. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |