How to use SUMIF from another sheet in Google Sheets
A simple guide on using SUMIF from another sheet in Google Sheets
How to sort results from UNIQUE function in Google Sheets
You can easily sort the UNIQUE results in Google Sheets using this formula:=UNIQUE(SORT(A1:A13)) Simply replace A1:A13 with your data range and you should be able to sort the results from…
How to split cell vertically in Google Sheets
A simple guide on how to split cell vertically in Google Sheets
How to create a progress bar based on the number of checklist completed in Google Sheets
A step by step guide to create a progress bar based on the number of checklist completed in Google Sheets
How to insert current date in Google Sheets
A simple guide to insert current date using functions and shortcut keys
How to remove spaces before and after text in Google Sheets
A simple step by step guide to removing spaces before and after text in Google Sheets
How to remove spaces between words in Google Sheets
A simple step by step guide to removing spaces between words in Google Sheets
How To Insert Alternate Blank Rows in Google Sheets (manually or automatically using App Script)
A simple step by step guide to inserting alternate blank rows in Google Sheets