Google Sheets

You can use the custom formula function in Google Sheets to highlight the highest value in a range. The following example shows…

The slope of a trendline represents the average increase in the y-value for a one unit increase in the x-value. To find…

You can use the following basic formula to generate the number of days in a month in Google Sheets: =DAY(EOMONTH(A2,0)) This particular…

The following step-by-step example shows how to calculate the average value by group in Google Sheets. Example: Calculate Average by Group in…

Often you may want to find duplicate values across two columns in Google Sheets. Fortunately this is easy to do using conditional…

Often you may want to count duplicate values in Google Sheets. Fortunately this is easy to do using the COUNTIF() function. The…

You can use the following basic syntax to concatenate strings with a space in Google Sheets: =CONCATENATE(A2, ” “, B2) This particular…

Often you may want to convert minutes to hours in Google Sheets. Fortunately this is easy to do and this tutorial explains…

You can use the following basic syntax to exclude a cell from a range when using a formula in Google Sheets: =SUM(FILTER(B2:B11,B2:B11B5))…

You can use the following formulas to remove specific substrings from cells in Google Sheets: Method 1: Remove One Substring from Cell…