Google Sheets

Excel provides a wide range of powerful functions to perform calculations and manipulate data. One such function is SUMIF, which allows you to sum values based on a specified condition…

A simple guide on to get sheet by name in Google Sheets using Apps Script

A simple guide to get spreadsheet ID in Google Sheets using Apps Script or via URL

A simple guide on how to count only rows with values in Google Sheets

A simple guide to create a color coded stock trendline using SPARKLINE in Google Sheets

A simple guide on using SUMIF from another sheet 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…

A simple guide on how to split cell vertically in Google Sheets

A step by step guide to create a progress bar based on the number of checklist completed in Google Sheets

A simple guide to insert current date using functions and shortcut keys