--- title: "Google Sheets Tips — Formulas & Templates | OWOX Blog" canonical: "https://www.owox.com/blog/topics/google-sheets-tips" updated: "2026-10-29" --- # Google Sheets Tips 82 articles · 5 videos [Article · Google Sheets Tips · Joined Data Marts in Google Sheets: One Report from Several Tables, No VLOOKUP Chains · Oct 11, 2026](/blog/articles/joinable-data-marts-google-sheets) [Article · Google Sheets Tips · Why Your Scheduled Refresh Keeps Wiping Google Sheets Formulas (and How to Fix It) · Oct 11, 2026](/blog/articles/refresh-sql-google-sheets-formulas) [Article · Google Sheets Tips · GA4 reports in Google Sheets: two ways to automate them · Oct 7, 2026](/blog/articles/google-analytics-reports-in-google-sheets) [Article · Google Sheets Tips · ARRAYFORMULA in Google Sheets: how to use array formulas, with examples · Oct 2, 2026](/blog/articles/array-formulas-google-sheets) [Article · Google Sheets Tips · How to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and AVERAGEIFS · Oct 2, 2026](/blog/articles/average-functions-google-sheets) [Article · Google Sheets Tips · How to make a bar graph in Google Sheets, with error bars · Oct 2, 2026](/blog/articles/bar-graphs-in-google-sheets) [Article · Google Sheets Tips · ROUND, CEILING and FLOOR in Google Sheets: which rounding function to use · Oct 2, 2026](/blog/articles/ceiling-floor-round-google-sheets) [Article · Google Sheets Tips · CHAR function in Google Sheets: list of codes and examples · Oct 2, 2026](/blog/articles/char-function-google-sheets) [Article · Google Sheets Tips · How to make a chart in Google Sheets: types and settings · Oct 2, 2026](/blog/articles/charts-for-visualization-google-sheets) [Article · Google Sheets Tips · CONCATENATE and & in Google Sheets: combine text from cells · Oct 2, 2026](/blog/articles/concatenate-and-ampersand-google-sheets) [Article · Google Sheets Tips · COUNT and COUNTA in Google Sheets: what each one counts, with examples · Oct 2, 2026](/blog/articles/count-and-counta-in-google-sheets) [Article · Google Sheets Tips · COUNTIF and COUNTIFS in Google Sheets: criteria and examples · Oct 2, 2026](/blog/articles/countif-and-countifs-google-sheets) [Article · Google Sheets Tips · Data validation in Google Sheets: rules, drop-down lists and custom formulas · Oct 2, 2026](/blog/articles/data-validation-google-sheets) [Article · Google Sheets Tips · How to filter by date with QUERY in Google Sheets · Oct 2, 2026](/blog/articles/date-filtering-with-query-google-sheets) [Article · Google Sheets Tips · Date functions in Google Sheets: DATE, DATEVALUE, DATEDIF, EDATE and EPOCHTODATE · Oct 2, 2026](/blog/articles/date-functions-google-sheets) [Article · Google Sheets Tips · Dates and times in Google Sheets: how they work, with formulas · Oct 2, 2026](/blog/articles/dates-and-times-google-sheets) [Article · Google Sheets Tips · DAY, DAYS and DAYS360 in Google Sheets: formulas and examples · Oct 2, 2026](/blog/articles/day-days-days360-functions-google-sheets) [Article · Google Sheets Tips · 7 Google Sheets features every marketer should know · Oct 2, 2026](/blog/articles/essential-features-for-marketers-google-sheets) [Article · Google Sheets Tips · EXACT function in Google Sheets: case-sensitive comparison, lookup and count · Oct 2, 2026](/blog/articles/exact-function-google-sheets) [Article · Google Sheets Tips · Exploratory data analysis in Google Sheets: a step-by-step guide · Oct 2, 2026](/blog/articles/exploratory-data-analysis-google-sheets) [Article · Google Sheets Tips · FIND and SEARCH functions in Google Sheets: differences, formulas and examples · Oct 2, 2026](/blog/articles/find-and-search-functions-google-sheets) [Article · Google Sheets Tips · FILTER function in Google Sheets: formula, conditions and examples · Oct 2, 2026](/blog/articles/google-sheets-filter-function) [Article · Google Sheets Tips · MATCH function in Google Sheets: find the position of a value · Oct 2, 2026](/blog/articles/google-sheets-match-function) [Article · Google Sheets Tips · How to convert currency in Google Sheets using GOOGLEFINANCE · Oct 2, 2026](/blog/articles/googlefinance-currency-conversion-google-sheets) [Article · Google Sheets Tips · GOOGLEFINANCE function in Google Sheets: syntax, attributes list and examples · Oct 2, 2026](/blog/articles/googlefinance-function-google-sheets) [Article · Google Sheets Tips · HLOOKUP in Google Sheets: syntax, examples and errors · Oct 2, 2026](/blog/articles/hlookup-function-google-sheets) [Article · Google Sheets Tips · Find and replace in Google Sheets: options, regex and examples · Oct 2, 2026](/blog/articles/how-to-find-and-replace-google-sheets) [Article · Google Sheets Tips · How to sort data in Google Sheets: by column, by multiple columns, by date and by color · Oct 2, 2026](/blog/articles/how-to-sort-data-google-sheets) [Article · Google Sheets Tips · How to split cells in Google Sheets: Split text to columns and the SPLIT function · Oct 2, 2026](/blog/articles/how-to-split-cells-in-google-sheets) [Article · Google Sheets Tips · How to use VLOOKUP with an IF statement in Google Sheets · Oct 2, 2026](/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets) [Article · Google Sheets Tips · How to wrap text in Google Sheets: menu, toolbar, line breaks and fixes · Oct 2, 2026](/blog/articles/how-to-wrap-text-google-sheets) [Article · Google Sheets Tips · IF function in Google Sheets: formula, IF with AND and OR, nested IF · Oct 2, 2026](/blog/articles/if-function-google-sheets) [Article · Google Sheets Tips · IFS function in Google Sheets: several conditions in one formula · Oct 2, 2026](/blog/articles/ifs-function-google-sheets) [Article · Google Sheets Tips · IMPORTDATA function in Google Sheets: import a CSV or TSV file from a URL · Oct 2, 2026](/blog/articles/importdata-google-sheets) [Article · Google Sheets Tips · IMPORTFEED function in Google Sheets: import an RSS or Atom feed · Oct 2, 2026](/blog/articles/importfeed-function-google-sheets) [Article · Google Sheets Tips · IMPORTHTML function in Google Sheets: import a table or a list from a web page · Oct 2, 2026](/blog/articles/importhtml-function-google-sheets) [Article · Google Sheets Tips · IMPORTRANGE in Google Sheets: formula, multiple ranges, examples and errors · Oct 2, 2026](/blog/articles/importrange-google-sheets) [Article · Google Sheets Tips · IMPORTXML in Google Sheets: syntax, XPath examples and errors · Oct 2, 2026](/blog/articles/importxml-function-google-sheets) [Article · Google Sheets Tips · How to use INDEX MATCH in Google Sheets: formula, examples and errors · Oct 2, 2026](/blog/articles/index-and-match-google-sheets) [Article · Google Sheets Tips · JOIN and TEXTJOIN in Google Sheets: join a range into one cell · Oct 2, 2026](/blog/articles/join-textjoin-functions-google-sheets) [Article · Google Sheets Tips · XLOOKUP vs VLOOKUP in Google Sheets: the key differences · Oct 2, 2026](/blog/articles/key-differences-of-xlookup-vs-vlookup) [Article · Google Sheets Tips · LEFT, RIGHT and MID in Google Sheets: extract part of a text · Oct 2, 2026](/blog/articles/left-right-mid-functions-google-sheets) [Article · Google Sheets Tips · LEN function in Google Sheets: count characters in a cell · Oct 2, 2026](/blog/articles/len-function-google-sheets) [Article · Google Sheets Tips · How to link cells, tabs and spreadsheets in Google Sheets · Oct 2, 2026](/blog/articles/linking-data-across-multiple-google-sheets) [Article · Google Sheets Tips · LOOKUP function in Google Sheets: syntax, examples and when to use another lookup · Oct 2, 2026](/blog/articles/lookup-function-google-sheets) [Article · Google Sheets Tips · MAX, MIN and MEDIAN in Google Sheets: formulas and examples · Oct 2, 2026](/blog/articles/max-min-median-functions-google-sheets) [Article · Google Sheets Tips · MONTH and EOMONTH functions in Google Sheets: formulas and examples · Oct 2, 2026](/blog/articles/month-eomonth-functions-google-sheets) [Article · Google Sheets Tips · NOW and TODAY functions in Google Sheets: current date and time, with examples · Oct 2, 2026](/blog/articles/now-today-functions-google-sheets) [Article · Google Sheets Tips · PERCENTILE function in Google Sheets: PERCENTILE.INC and PERCENTILE.EXC with examples · Oct 2, 2026](/blog/articles/percentile-function-google-sheets) [Article · Google Sheets Tips · PERCENTRANK function in Google Sheets: the percentile rank of a value · Oct 2, 2026](/blog/articles/percentrank-function-google-sheets) [Article · Google Sheets Tips · Pivot charts in Google Sheets: how to make a chart from a pivot table · Oct 2, 2026](/blog/articles/pivot-charts-google-sheets) [Article · Google Sheets Tips · Pivot tables in Google Sheets: how to create, customize and use them · Oct 2, 2026](/blog/articles/pivot-tables-google-sheets) [Article · Google Sheets Tips · Pivot tables and charts in Google Sheets: from a raw table to a report · Oct 2, 2026](/blog/articles/pivots-and-charts-in-google-sheets) [Article · Google Sheets Tips · QUARTILE function in Google Sheets: how to calculate quartiles, the IQR and outliers · Oct 2, 2026](/blog/articles/quartile-function-google-sheets) [Article · Google Sheets Tips · QUERY function in Google Sheets: syntax, clauses and examples · Oct 2, 2026](/blog/articles/query-function-google-sheets) [Article · Google Sheets Tips · QUERY vs VLOOKUP in Google Sheets: which one to use · Oct 2, 2026](/blog/articles/query-vs-vlookup-google-sheets) [Article · Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: how to concatenate two columns · Oct 2, 2026](/blog/articles/query-with-concatenate-google-sheets) [Article · Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: formula and 12 examples · Oct 2, 2026](/blog/articles/query-with-importrange-google-sheets) [Article · Google Sheets Tips · QUERY with UNIQUE in Google Sheets: how to return distinct rows · Oct 2, 2026](/blog/articles/query-with-unique-google-sheets) [Article · Google Sheets Tips · RANK function in Google Sheets: RANK, RANK.EQ and RANK.AVG · Oct 2, 2026](/blog/articles/rank-function-google-sheets) [Article · Google Sheets Tips · REGEX functions in Google Sheets: REGEXMATCH, REGEXEXTRACT and REGEXREPLACE · Oct 2, 2026](/blog/articles/regex-functions-google-sheets) [Article · Google Sheets Tips · How to remove duplicates in Google Sheets, and prevent them · Oct 2, 2026](/blog/articles/remove-duplicates-google-sheets) [Article · Google Sheets Tips · REPLACE function in Google Sheets: syntax and examples · Oct 2, 2026](/blog/articles/replace-function-google-sheets) [Article · Google Sheets Tips · REPT function in Google Sheets: repeat text, pad values and draw in-cell bars · Oct 2, 2026](/blog/articles/rept-function-google-sheets) [Article · Google Sheets Tips · How to search in Google Sheets: Find, find and replace, and the SEARCH function · Oct 2, 2026](/blog/articles/search-function-google-sheets) [Article · Google Sheets Tips · Slicers in Google Sheets: how to add, use and save them · Oct 2, 2026](/blog/articles/slicers-google-sheets) [Article · Google Sheets Tips · SORT and SORTN in Google Sheets: syntax, top N and ties · Oct 2, 2026](/blog/articles/sort-and-sortn-functions-google-sheets) [Article · Google Sheets Tips · SPARKLINE in Google Sheets: chart types, options and examples · Oct 2, 2026](/blog/articles/sparkline-google-sheets) [Article · Google Sheets Tips · SUBSTITUTE function in Google Sheets: replace text, the nth occurrence and multiple values · Oct 2, 2026](/blog/articles/substitute-function-google-sheets) [Article · Google Sheets Tips · How to sum in Google Sheets: SUM, SUMIF and SUMIFS with examples · Oct 2, 2026](/blog/articles/sum-functions-google-sheets) [Article · Google Sheets Tips · Tables in Google Sheets: how to create, format and reference them · Oct 2, 2026](/blog/articles/tables-feature-google-sheets) [Article · Google Sheets Tips · TEXT function in Google Sheets: format codes for numbers, dates and times · Oct 2, 2026](/blog/articles/text-function-google-sheets) [Article · Google Sheets Tips · How to calculate time in Google Sheets: add, subtract and the TIME functions · Oct 2, 2026](/blog/articles/time-functions-google-sheets) [Article · Google Sheets Tips · TRIM, CLEAN and T functions in Google Sheets: remove extra spaces and hidden characters · Oct 2, 2026](/blog/articles/trim-clean-t-functions-google-sheets) [Article · Google Sheets Tips · UNIQUE function in Google Sheets: syntax, examples and common errors · Oct 2, 2026](/blog/articles/unique-function-google-sheets) [Article · Google Sheets Tips · UPPER, LOWER and PROPER in Google Sheets: change text case · Oct 2, 2026](/blog/articles/upper-lower-proper-functions-google-sheets) [Article · Google Sheets Tips · VLOOKUP in Google Sheets: formula, VLOOKUP from another sheet, and examples · Oct 2, 2026](/blog/articles/vlookup-in-google-sheets) [Article · Google Sheets Tips · VLOOKUP with multiple criteria in Google Sheets: 5 ways · Oct 2, 2026](/blog/articles/vlookup-with-multiple-criteria-google-sheets) [Article · Google Sheets Tips · Day of the week and week number in Google Sheets: WEEKDAY, WEEKNUM and ISOWEEKNUM · Oct 2, 2026](/blog/articles/weekday-weeknum-functions-google-sheets) [Article · Google Sheets Tips · WORKDAY and NETWORKDAYS in Google Sheets: how to count working days · Oct 2, 2026](/blog/articles/workday-networkdays-functions-google-sheets) [Article · Google Sheets Tips · YEAR and YEARFRAC functions in Google Sheets: get the year from a date and the years between two dates · Oct 2, 2026](/blog/articles/year-yearfrac-google-sheets) [Article · Google Sheets Tips · Stop delegating tasks with data screenshots that are wrong by morning · Jul 22, 2026](/blog/articles/delegate-data-tasks-google-sheets) ## Videos * [ARRAYFORMULA in Google Sheets](/video/arrayformula-in-google-sheets) * [How to Split Cells in Google Sheets](/video/how-to-split-cells-in-google-sheets) * [QUERY Function in Google Sheets](/video/query-function-in-google-sheets) * [UNIQUE Function in Google Sheets](/video/unique-function-in-google-sheets) * [VLOOKUP in Google Sheets](/video/vlookup-in-google-sheets) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting ## Schedule in person meeting at Data Outpost San Francisco You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Article · Google Sheets Tips · Joined Data Marts in Google Sheets: One Report from Several Tables,…](https://www.owox.com/blog/articles/joinable-data-marts-google-sheets) — /blog/articles/joinable-data-marts-google-sheets.md - [Article · Google Sheets Tips · Why Your Scheduled Refresh Keeps Wiping Google Sheets Formulas (and…](https://www.owox.com/blog/articles/refresh-sql-google-sheets-formulas) — /blog/articles/refresh-sql-google-sheets-formulas.md - [Article · Google Sheets Tips · GA4 reports in Google Sheets: two ways to automate them · Oct 7, 2026](https://www.owox.com/blog/articles/google-analytics-reports-in-google-sheets) — /blog/articles/google-analytics-reports-in-google-sheets.md - [Article · Google Sheets Tips · ARRAYFORMULA in Google Sheets: how to use array formulas, with…](https://www.owox.com/blog/articles/array-formulas-google-sheets) — /blog/articles/array-formulas-google-sheets.md - [Article · Google Sheets Tips · How to calculate an average in Google Sheets: AVERAGE, AVERAGEIF and…](https://www.owox.com/blog/articles/average-functions-google-sheets) — /blog/articles/average-functions-google-sheets.md - [Article · Google Sheets Tips · How to make a bar graph in Google Sheets, with error bars · Oct 2,…](https://www.owox.com/blog/articles/bar-graphs-in-google-sheets) — /blog/articles/bar-graphs-in-google-sheets.md - [Article · Google Sheets Tips · ROUND, CEILING and FLOOR in Google Sheets: which rounding function to…](https://www.owox.com/blog/articles/ceiling-floor-round-google-sheets) — /blog/articles/ceiling-floor-round-google-sheets.md - [Article · Google Sheets Tips · CHAR function in Google Sheets: list of codes and examples · Oct 2,…](https://www.owox.com/blog/articles/char-function-google-sheets) — /blog/articles/char-function-google-sheets.md - [Article · Google Sheets Tips · How to make a chart in Google Sheets: types and settings · Oct 2,…](https://www.owox.com/blog/articles/charts-for-visualization-google-sheets) — /blog/articles/charts-for-visualization-google-sheets.md - [Article · Google Sheets Tips · CONCATENATE and & in Google Sheets: combine text from cells · Oct 2,…](https://www.owox.com/blog/articles/concatenate-and-ampersand-google-sheets) — /blog/articles/concatenate-and-ampersand-google-sheets.md - [Article · Google Sheets Tips · COUNT and COUNTA in Google Sheets: what each one counts, with…](https://www.owox.com/blog/articles/count-and-counta-in-google-sheets) — /blog/articles/count-and-counta-in-google-sheets.md - [Article · Google Sheets Tips · COUNTIF and COUNTIFS in Google Sheets: criteria and examples · Oct 2,…](https://www.owox.com/blog/articles/countif-and-countifs-google-sheets) — /blog/articles/countif-and-countifs-google-sheets.md - [Article · Google Sheets Tips · Data validation in Google Sheets: rules, drop-down lists and custom…](https://www.owox.com/blog/articles/data-validation-google-sheets) — /blog/articles/data-validation-google-sheets.md - [Article · Google Sheets Tips · How to filter by date with QUERY in Google Sheets · Oct 2, 2026](https://www.owox.com/blog/articles/date-filtering-with-query-google-sheets) — /blog/articles/date-filtering-with-query-google-sheets.md - [Article · Google Sheets Tips · Date functions in Google Sheets: DATE, DATEVALUE, DATEDIF, EDATE and…](https://www.owox.com/blog/articles/date-functions-google-sheets) — /blog/articles/date-functions-google-sheets.md - [Article · Google Sheets Tips · Dates and times in Google Sheets: how they work, with formulas · Oct…](https://www.owox.com/blog/articles/dates-and-times-google-sheets) — /blog/articles/dates-and-times-google-sheets.md - [Article · Google Sheets Tips · DAY, DAYS and DAYS360 in Google Sheets: formulas and examples · Oct…](https://www.owox.com/blog/articles/day-days-days360-functions-google-sheets) — /blog/articles/day-days-days360-functions-google-sheets.md - [Article · Google Sheets Tips · 7 Google Sheets features every marketer should know · Oct 2, 2026](https://www.owox.com/blog/articles/essential-features-for-marketers-google-sheets) — /blog/articles/essential-features-for-marketers-google-sheets.md - [Article · Google Sheets Tips · EXACT function in Google Sheets: case-sensitive comparison, lookup…](https://www.owox.com/blog/articles/exact-function-google-sheets) — /blog/articles/exact-function-google-sheets.md - [Article · Google Sheets Tips · Exploratory data analysis in Google Sheets: a step-by-step guide ·…](https://www.owox.com/blog/articles/exploratory-data-analysis-google-sheets) — /blog/articles/exploratory-data-analysis-google-sheets.md - [Article · Google Sheets Tips · FIND and SEARCH functions in Google Sheets: differences, formulas and…](https://www.owox.com/blog/articles/find-and-search-functions-google-sheets) — /blog/articles/find-and-search-functions-google-sheets.md - [Article · Google Sheets Tips · FILTER function in Google Sheets: formula, conditions and examples ·…](https://www.owox.com/blog/articles/google-sheets-filter-function) — /blog/articles/google-sheets-filter-function.md - [Article · Google Sheets Tips · MATCH function in Google Sheets: find the position of a value · Oct…](https://www.owox.com/blog/articles/google-sheets-match-function) — /blog/articles/google-sheets-match-function.md - [Article · Google Sheets Tips · How to convert currency in Google Sheets using GOOGLEFINANCE · Oct 2,…](https://www.owox.com/blog/articles/googlefinance-currency-conversion-google-sheets) — /blog/articles/googlefinance-currency-conversion-google-sheets.md - [Article · Google Sheets Tips · GOOGLEFINANCE function in Google Sheets: syntax, attributes list and…](https://www.owox.com/blog/articles/googlefinance-function-google-sheets) — /blog/articles/googlefinance-function-google-sheets.md - [Article · Google Sheets Tips · HLOOKUP in Google Sheets: syntax, examples and errors · Oct 2, 2026](https://www.owox.com/blog/articles/hlookup-function-google-sheets) — /blog/articles/hlookup-function-google-sheets.md - [Article · Google Sheets Tips · Find and replace in Google Sheets: options, regex and examples · Oct…](https://www.owox.com/blog/articles/how-to-find-and-replace-google-sheets) — /blog/articles/how-to-find-and-replace-google-sheets.md - [Article · Google Sheets Tips · How to sort data in Google Sheets: by column, by multiple columns, by…](https://www.owox.com/blog/articles/how-to-sort-data-google-sheets) — /blog/articles/how-to-sort-data-google-sheets.md - [Article · Google Sheets Tips · How to split cells in Google Sheets: Split text to columns and the…](https://www.owox.com/blog/articles/how-to-split-cells-in-google-sheets) — /blog/articles/how-to-split-cells-in-google-sheets.md - [Article · Google Sheets Tips · How to use VLOOKUP with an IF statement in Google Sheets · Oct 2,…](https://www.owox.com/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets) — /blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets.md - [Article · Google Sheets Tips · How to wrap text in Google Sheets: menu, toolbar, line breaks and…](https://www.owox.com/blog/articles/how-to-wrap-text-google-sheets) — /blog/articles/how-to-wrap-text-google-sheets.md - [Article · Google Sheets Tips · IF function in Google Sheets: formula, IF with AND and OR, nested IF…](https://www.owox.com/blog/articles/if-function-google-sheets) — /blog/articles/if-function-google-sheets.md - [Article · Google Sheets Tips · IFS function in Google Sheets: several conditions in one formula ·…](https://www.owox.com/blog/articles/ifs-function-google-sheets) — /blog/articles/ifs-function-google-sheets.md - [Article · Google Sheets Tips · IMPORTDATA function in Google Sheets: import a CSV or TSV file from a…](https://www.owox.com/blog/articles/importdata-google-sheets) — /blog/articles/importdata-google-sheets.md - [Article · Google Sheets Tips · IMPORTFEED function in Google Sheets: import an RSS or Atom feed ·…](https://www.owox.com/blog/articles/importfeed-function-google-sheets) — /blog/articles/importfeed-function-google-sheets.md - [Article · Google Sheets Tips · IMPORTHTML function in Google Sheets: import a table or a list from a…](https://www.owox.com/blog/articles/importhtml-function-google-sheets) — /blog/articles/importhtml-function-google-sheets.md - [Article · Google Sheets Tips · IMPORTRANGE in Google Sheets: formula, multiple ranges, examples and…](https://www.owox.com/blog/articles/importrange-google-sheets) — /blog/articles/importrange-google-sheets.md - [Article · Google Sheets Tips · IMPORTXML in Google Sheets: syntax, XPath examples and errors · Oct…](https://www.owox.com/blog/articles/importxml-function-google-sheets) — /blog/articles/importxml-function-google-sheets.md - [Article · Google Sheets Tips · How to use INDEX MATCH in Google Sheets: formula, examples and errors…](https://www.owox.com/blog/articles/index-and-match-google-sheets) — /blog/articles/index-and-match-google-sheets.md - [Article · Google Sheets Tips · JOIN and TEXTJOIN in Google Sheets: join a range into one cell · Oct…](https://www.owox.com/blog/articles/join-textjoin-functions-google-sheets) — /blog/articles/join-textjoin-functions-google-sheets.md - [Article · Google Sheets Tips · XLOOKUP vs VLOOKUP in Google Sheets: the key differences · Oct 2,…](https://www.owox.com/blog/articles/key-differences-of-xlookup-vs-vlookup) — /blog/articles/key-differences-of-xlookup-vs-vlookup.md - [Article · Google Sheets Tips · LEFT, RIGHT and MID in Google Sheets: extract part of a text · Oct 2,…](https://www.owox.com/blog/articles/left-right-mid-functions-google-sheets) — /blog/articles/left-right-mid-functions-google-sheets.md - [Article · Google Sheets Tips · LEN function in Google Sheets: count characters in a cell · Oct 2,…](https://www.owox.com/blog/articles/len-function-google-sheets) — /blog/articles/len-function-google-sheets.md - [Article · Google Sheets Tips · How to link cells, tabs and spreadsheets in Google Sheets · Oct 2,…](https://www.owox.com/blog/articles/linking-data-across-multiple-google-sheets) — /blog/articles/linking-data-across-multiple-google-sheets.md - [Article · Google Sheets Tips · LOOKUP function in Google Sheets: syntax, examples and when to use…](https://www.owox.com/blog/articles/lookup-function-google-sheets) — /blog/articles/lookup-function-google-sheets.md - [Article · Google Sheets Tips · MAX, MIN and MEDIAN in Google Sheets: formulas and examples · Oct 2,…](https://www.owox.com/blog/articles/max-min-median-functions-google-sheets) — /blog/articles/max-min-median-functions-google-sheets.md - [Article · Google Sheets Tips · MONTH and EOMONTH functions in Google Sheets: formulas and examples ·…](https://www.owox.com/blog/articles/month-eomonth-functions-google-sheets) — /blog/articles/month-eomonth-functions-google-sheets.md - [Article · Google Sheets Tips · NOW and TODAY functions in Google Sheets: current date and time, with…](https://www.owox.com/blog/articles/now-today-functions-google-sheets) — /blog/articles/now-today-functions-google-sheets.md - [Article · Google Sheets Tips · PERCENTILE function in Google Sheets: PERCENTILE.INC and…](https://www.owox.com/blog/articles/percentile-function-google-sheets) — /blog/articles/percentile-function-google-sheets.md - [Article · Google Sheets Tips · PERCENTRANK function in Google Sheets: the percentile rank of a value…](https://www.owox.com/blog/articles/percentrank-function-google-sheets) — /blog/articles/percentrank-function-google-sheets.md - [Article · Google Sheets Tips · Pivot charts in Google Sheets: how to make a chart from a pivot table…](https://www.owox.com/blog/articles/pivot-charts-google-sheets) — /blog/articles/pivot-charts-google-sheets.md - [Article · Google Sheets Tips · Pivot tables in Google Sheets: how to create, customize and use them…](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md - [Article · Google Sheets Tips · Pivot tables and charts in Google Sheets: from a raw table to a…](https://www.owox.com/blog/articles/pivots-and-charts-in-google-sheets) — /blog/articles/pivots-and-charts-in-google-sheets.md - [Article · Google Sheets Tips · QUARTILE function in Google Sheets: how to calculate quartiles, the…](https://www.owox.com/blog/articles/quartile-function-google-sheets) — /blog/articles/quartile-function-google-sheets.md - [Article · Google Sheets Tips · QUERY function in Google Sheets: syntax, clauses and examples · Oct…](https://www.owox.com/blog/articles/query-function-google-sheets) — /blog/articles/query-function-google-sheets.md - [Article · Google Sheets Tips · QUERY vs VLOOKUP in Google Sheets: which one to use · Oct 2, 2026](https://www.owox.com/blog/articles/query-vs-vlookup-google-sheets) — /blog/articles/query-vs-vlookup-google-sheets.md - [Article · Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: how to concatenate two…](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md - [Article · Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: formula and 12 examples ·…](https://www.owox.com/blog/articles/query-with-importrange-google-sheets) — /blog/articles/query-with-importrange-google-sheets.md - [Article · Google Sheets Tips · QUERY with UNIQUE in Google Sheets: how to return distinct rows · Oct…](https://www.owox.com/blog/articles/query-with-unique-google-sheets) — /blog/articles/query-with-unique-google-sheets.md - [Article · Google Sheets Tips · RANK function in Google Sheets: RANK, RANK.EQ and RANK.AVG · Oct 2,…](https://www.owox.com/blog/articles/rank-function-google-sheets) — /blog/articles/rank-function-google-sheets.md - [Article · Google Sheets Tips · REGEX functions in Google Sheets: REGEXMATCH, REGEXEXTRACT and…](https://www.owox.com/blog/articles/regex-functions-google-sheets) — /blog/articles/regex-functions-google-sheets.md - [Article · Google Sheets Tips · How to remove duplicates in Google Sheets, and prevent them · Oct 2,…](https://www.owox.com/blog/articles/remove-duplicates-google-sheets) — /blog/articles/remove-duplicates-google-sheets.md - [Article · Google Sheets Tips · REPLACE function in Google Sheets: syntax and examples · Oct 2, 2026](https://www.owox.com/blog/articles/replace-function-google-sheets) — /blog/articles/replace-function-google-sheets.md - [Article · Google Sheets Tips · REPT function in Google Sheets: repeat text, pad values and draw…](https://www.owox.com/blog/articles/rept-function-google-sheets) — /blog/articles/rept-function-google-sheets.md - [Article · Google Sheets Tips · How to search in Google Sheets: Find, find and replace, and the…](https://www.owox.com/blog/articles/search-function-google-sheets) — /blog/articles/search-function-google-sheets.md - [Article · Google Sheets Tips · Slicers in Google Sheets: how to add, use and save them · Oct 2, 2026](https://www.owox.com/blog/articles/slicers-google-sheets) — /blog/articles/slicers-google-sheets.md - [Article · Google Sheets Tips · SORT and SORTN in Google Sheets: syntax, top N and ties · Oct 2, 2026](https://www.owox.com/blog/articles/sort-and-sortn-functions-google-sheets) — /blog/articles/sort-and-sortn-functions-google-sheets.md - [Article · Google Sheets Tips · SPARKLINE in Google Sheets: chart types, options and examples · Oct…](https://www.owox.com/blog/articles/sparkline-google-sheets) — /blog/articles/sparkline-google-sheets.md - [Article · Google Sheets Tips · SUBSTITUTE function in Google Sheets: replace text, the nth…](https://www.owox.com/blog/articles/substitute-function-google-sheets) — /blog/articles/substitute-function-google-sheets.md - [Article · Google Sheets Tips · How to sum in Google Sheets: SUM, SUMIF and SUMIFS with examples ·…](https://www.owox.com/blog/articles/sum-functions-google-sheets) — /blog/articles/sum-functions-google-sheets.md - [Article · Google Sheets Tips · Tables in Google Sheets: how to create, format and reference them ·…](https://www.owox.com/blog/articles/tables-feature-google-sheets) — /blog/articles/tables-feature-google-sheets.md - [Article · Google Sheets Tips · TEXT function in Google Sheets: format codes for numbers, dates and…](https://www.owox.com/blog/articles/text-function-google-sheets) — /blog/articles/text-function-google-sheets.md - [Article · Google Sheets Tips · How to calculate time in Google Sheets: add, subtract and the TIME…](https://www.owox.com/blog/articles/time-functions-google-sheets) — /blog/articles/time-functions-google-sheets.md - [Article · Google Sheets Tips · TRIM, CLEAN and T functions in Google Sheets: remove extra spaces and…](https://www.owox.com/blog/articles/trim-clean-t-functions-google-sheets) — /blog/articles/trim-clean-t-functions-google-sheets.md - [Article · Google Sheets Tips · UNIQUE function in Google Sheets: syntax, examples and common errors…](https://www.owox.com/blog/articles/unique-function-google-sheets) — /blog/articles/unique-function-google-sheets.md - [Article · Google Sheets Tips · UPPER, LOWER and PROPER in Google Sheets: change text case · Oct 2,…](https://www.owox.com/blog/articles/upper-lower-proper-functions-google-sheets) — /blog/articles/upper-lower-proper-functions-google-sheets.md - [Article · Google Sheets Tips · VLOOKUP in Google Sheets: formula, VLOOKUP from another sheet, and…](https://www.owox.com/blog/articles/vlookup-in-google-sheets) — /blog/articles/vlookup-in-google-sheets.md - [Article · Google Sheets Tips · VLOOKUP with multiple criteria in Google Sheets: 5 ways · Oct 2, 2026](https://www.owox.com/blog/articles/vlookup-with-multiple-criteria-google-sheets) — /blog/articles/vlookup-with-multiple-criteria-google-sheets.md - [Article · Google Sheets Tips · Day of the week and week number in Google Sheets: WEEKDAY, WEEKNUM…](https://www.owox.com/blog/articles/weekday-weeknum-functions-google-sheets) — /blog/articles/weekday-weeknum-functions-google-sheets.md - [Article · Google Sheets Tips · WORKDAY and NETWORKDAYS in Google Sheets: how to count working days ·…](https://www.owox.com/blog/articles/workday-networkdays-functions-google-sheets) — /blog/articles/workday-networkdays-functions-google-sheets.md - [Article · Google Sheets Tips · YEAR and YEARFRAC functions in Google Sheets: get the year from a…](https://www.owox.com/blog/articles/year-yearfrac-google-sheets) — /blog/articles/year-yearfrac-google-sheets.md - [Article · Google Sheets Tips · Stop delegating tasks with data screenshots that are wrong by morning…](https://www.owox.com/blog/articles/delegate-data-tasks-google-sheets) — /blog/articles/delegate-data-tasks-google-sheets.md - [ARRAYFORMULA in Google Sheets](https://www.owox.com/video/arrayformula-in-google-sheets) — /video/arrayformula-in-google-sheets.md - [How to Split Cells in Google Sheets](https://www.owox.com/video/how-to-split-cells-in-google-sheets) — /video/how-to-split-cells-in-google-sheets.md - [QUERY Function in Google Sheets](https://www.owox.com/video/query-function-in-google-sheets) — /video/query-function-in-google-sheets.md - [UNIQUE Function in Google Sheets](https://www.owox.com/video/unique-function-in-google-sheets) — /video/unique-function-in-google-sheets.md - [VLOOKUP in Google Sheets](https://www.owox.com/video/vlookup-in-google-sheets) — /video/vlookup-in-google-sheets.md