trafixxo

Is there a way we can count or display the sum of bold text in the spreadsheet? Solution: Running a script in Google Apps Script. Cons:      - when the text is changed or updated the sum or count does not update      - need to run the script every time when you edit the spreadsheet function countboldcells () { var book = SpreadsheetApp.getActiveSpreadsheet(); var sheet = book.getActiveSheet(); var range_input = sheet.getRange( "A2:A18" ); var range_output = sheet.getRange( "A19" ); var cell_styles = range_input.getFontWeights(); // getFontStyle can only return 'italic' or 'normal' var count = 0 ; for ( var r = 0 ; r < cell_styles.length; r++) { for ( var c = 0 ; c < cell_styles[ 0 ].length; c++) { // isBold is a method for Google Documents only (not sheets) if (cell_styles[r][c] === "bold" ) { // you need at least two '=' signs // also include the index of cell_styles count = count + 1 ; // count += 1 would al...

In this blog, I will teach you how to remove an image or photo backgrounds in an easier and faster way.  This website is being used by more than millions of users.If you are a non-technical user and you need simple tasks like this, just follow these easy steps and you’ll have amazing results. Open your browser Any browser will do. It is also working on your mobile phones and tablets. Type remove.bg in the Search Bar Once the URL has been typed in the search bar, it will redirect you to its website. Upload Image In this part, you will need to upload the image or the photo you want the background to be removed. Once uploaded it will automatically remove the image background. Save the file The most convenient part of this website is the saving part. Just double click the image with no background and it will automatically download the finished file.

What is Paymaya? It is an app that lets you earn extra cashback and rebates, allows you to shop, book online, and other things you can do online. You will also get a prepaid virtual card for easy access to your online transactions. What I love about this app is that it will let you pay bills online, buy a discounted prepaid load, and earn cashback in every transaction you’ve made with this app. In this blog, I’m gonna teach you some ways to earn extra cash, or let’s say how to save extra cash using this app. 1. Register and Get P50 using this code “r2f7um” You must first create an account to enjoy the perks of using Paymaya application. Use this code “ r2f7um” as an invite or referral code for you to get P50. You and your referred will both receive P50 after a successful application. Don’t forget to use “ r2f7um” as your referral code. It is one way to earn extra cash by referring friends to use Paymaya. You will receive a notification like this if you h...

Usually, ads should be displayed when you have an internet connection. But, in Infinix Note 4 it's like you have built-in "Ads". This is something irritating. To solve your problem in your mobile, follow the instructions on how to get rid of this "apps ads". There are two settings you need to navigate to hide or remove these annoying ads. To remove or hide the "Instant Apps" To remove or turn off "Application Recommendation" 1. Press the "Home Widget" to navigate all the apps installed in your phone. 2. Press the three (3) dots (:) aligned horizontally, found in the right corner of the search bar 3. Press the option "Hide the Instant Apps" To remove or hide App Recommendation 1. Long Press on your home screen. 2. Press the "Menu Button" 3. Find and select the "Other Settings" 4. Turn off the settings for Application Recommendation (by swiping the button from ...

You might want to remove the Search Bar displayed in your Infinix Note 4 phone but you don't know how to. Here is the guide to remove or disable the Search Bar on your mobile phone. 1. Long Press on your home screen. 2. Press the "Menu Button" 3. Find and select the "Other Settings" 4. Turn off the settings for Search Bar (by swiping the button from right to left and it will turn from color green into gray color) And, if you wanted to display it again. Just follow the same procedure and turn on the setting for the Search Bar. If you wish to display it again just swipe the button from left to right (from the color gray will turn into green).

When you upgrade your Infinix Note 4 all the settings will turn into the default setting. Maybe, like me, you don't want to see the "headlines" when you swipe on your screen. Here is how to remove or hide headlines. 1. Long Press on your home screen. 2. Press the "Menu Button" 3. Find and select the "Other Settings" 4. Turn off the settings for Headlines (by swiping the button from right to left and it will turn from color green into gray color) And, if you wanted to display it again. Just follow the same procedure and turn on the setting for the Headlines. If you wish to display it again just swipe the button from left to right (from the color gray will turn into green).