While working with Google Sheets, you may end up with a lot of empty cells and rows within your spreadsheet. This could be a result of your data having empty rows in it, or maybe you have deleted a few rows and ended up with these. If there are only a few empty rows, then […]
How to delete empty rows in google sheet Read More »
XLSX files is a Microsoft excel extension spreadsheet application that replaced the previously used Excels’ proprietary XLS. It uses tables to analyze, organize, and store data. It is the default format when creating a spreadsheet using Microsoft Excel modern formats. It is organized into cells per sheet which form numbered rows and columns. The application
How to convert xlsx to google sheets Read More »
At times when working with google sheets, we come across data requiring us to count the number of unique occurrences of the dataset. The best way to easily achieve this is by using Google sheets syntax formula COUNTUNIQUE( Value1,[value2,….]). This will give the total number of unique values is a certain set of data. Value1
How to count unique values in google sheets Read More »
