{"id":442288,"date":"2022-05-05T15:00:53","date_gmt":"2022-05-05T12:00:53","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/14-google-sheets-functions-that-microsoft-excel-needs\/"},"modified":"2022-05-05T15:00:53","modified_gmt":"2022-05-05T12:00:53","slug":"14-google-sheets-functions-that-microsoft-excel-needs","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/","title":{"rendered":"#14 Google Sheets Functions That Microsoft Excel Needs"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a4088575a720\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a4088575a720\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#%E2%80%9C14_Google_Sheets_Functions_That_Microsoft_Excel_Needs%E2%80%9D\" >&#8220;14 Google Sheets Functions That Microsoft Excel Needs&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Basic_Calculations_ADD_MINUS_MULTIPLY_and_DIVIDE\" >Basic Calculations: ADD, MINUS, MULTIPLY, and DIVIDE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Count_Unique_Values_COUNTUNIQUE\" >Count Unique Values: COUNTUNIQUE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Language_Functions_DETECTLANGUAGE_and_GOOGLETRANSLATE\" >Language Functions: DETECTLANGUAGE and GOOGLETRANSLATE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Greater_Than_Less_Than_and_Equal_to_GT_GTE_LT_LTE_EQ\" >Greater Than, Less Than, and Equal to: GT, GTE, LT, LTE, EQ<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Insert_and_Customize_a_Picture_IMAGE\" >Insert and Customize a Picture: IMAGE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/14-google-sheets-functions-that-microsoft-excel-needs\/#Add_a_Mini_Graph_SPARKLINE\" >Add a Mini Graph: SPARKLINE<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9C14_Google_Sheets_Functions_That_Microsoft_Excel_Needs%E2%80%9D\"><\/span>&#8220;14 Google Sheets Functions That Microsoft Excel Needs&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<figure style=\"width: 1200px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage size-full wp-image-796089\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/microsoft-excel-google-sheets-app-icons.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/microsoft-excel-google-sheets-app-icons.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/microsoft-excel-google-sheets-app-icons.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Closeup of a smartphone's screen showing Microsoft Office apps next to Google apps.\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><figcaption class=\"wp-caption-text\"><span class=\"type:primaryImage imagecredit\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.shutterstock.com\/image-photo\/portland-usa-mar-15-2021-office-1936682161\">Tada Images\/Shutterstock.com<\/a><\/span><\/figcaption><\/figure>\n<p>Microsoft Excel is a full-featured, commonly used spreadsheet <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lication, but it\u2019s not perfect. Its longtime rival Google Sheets offers features that Excel does not, including many helpful functions. Let\u2019s take a look!<\/p>\n<p>This list isn\u2019t all-inclusive, and Excel could add one or more of these functions at any time. But as of this writing in April 2022, these are the Google Sheets functions that we\u2019d love to see in Microsoft Excel. As a bonus, we\u2019ll show you how to use each one in Google Sheets in case you\u2019re new to these.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Basic_Calculations_ADD_MINUS_MULTIPLY_and_DIVIDE\"><\/span>Basic Calculations: ADD, MINUS, MULTIPLY, and DIVIDE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can certainly <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/761997\/how-to-add-numbers-in-microsoft-excel\/\">add, subtract, multiply, and divide numbers in Microsoft Excel. However, these common equations are done with formulas and operators, not functions. Excel does offers the SUM function, which works like ADD, but having a clear and unified collection of functions to work with makes for easier organization and workflow.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Add Numbers in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for each function in Google Sheets is the same with the function name and two arguments. So, <code>ADD(value1, value2)<\/code>, <code>MINUS(value1, value2,)<\/code>, and so on. You can insert the values, use cell references, or enter a combination of both.<\/p>\n<p>To subtract the values in cells A1 and A2, you would use this formula:<\/p>\n<pre>=MINUS(A1,A2)<\/pre>\n<p>To subtract 10 from the value in cell A1, you would use this formula:<\/p>\n<pre>=MINUS(A1,10)<\/pre>\n<p>To subtract 10 from 20, you would use this formula:<\/p>\n<pre>=MINUS(20,10)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795940\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/MINUS-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"MINUS function in Google Sheets\" width=\"650\" height=\"111\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Count_Unique_Values_COUNTUNIQUE\"><\/span>Count Unique Values: COUNTUNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you ever need to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/792407\/count-unique-values-in-excel\/\">count the number of distinct values in Google Sheets, then COUNTUNIQUE is your function. Count the number of customers who ordered once, products without inventory, or anything else where you want unique values using this function.<\/p>\n<p>The syntax for the function is <code>COUNTUNIQUE(value1, value2, ...)<\/code> where the first argument is required. You can use cell references or inserted values.<\/p>\n<p>To find the count of unique customers in our range A1 through A10, we can quickly see who ordered once using this formula.<\/p>\n<pre>=COUNTUNIQUE(A1:A10)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795938\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/COUNTUNIQUENames-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTUNIQUE for text\" width=\"384\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To count the unique values in a list of inserted values, you can use this formula replacing the values with your own:<\/p>\n<pre>=COUNTUNIQUE(1,2,3,3,3,4)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795939\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/COUNTUNIQUEValues-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTUNIQUE for values\" width=\"500\" height=\"135\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Count Unique Values in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Language_Functions_DETECTLANGUAGE_and_GOOGLETRANSLATE\"><\/span>Language Functions: DETECTLANGUAGE and GOOGLETRANSLATE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Spreadsheets aren\u2019t just about numbers and calculations. You may be <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/753171\/how-to-share-documents-on-google-docs-sheets-and-slides\/\">working on a sheet with others who speak a different dialect. With DETECTLANGUAGE you can identify the dialect of text and with GOOGLETRANSLATE you can translate text to another language.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Share Documents on Google Docs, Sheets, and Slides<\/em><\/strong><\/p>\n<p>The syntax for the first function is <code>DETECTLANGUAGE(text)<\/code> where you can enter the actual text or a cell reference.<\/p>\n<p>To identify the language in cell A1, you would use the following formula:<\/p>\n<pre>=DETECTLANGUAGE(A1)<\/pre>\n<p>To identify the language of specific text, you would use this formula with your own text inserted between the quotes:<\/p>\n<pre>=DETECTLANGUAGE(\"Bon Jour\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795942\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/DETECTLANGUAGE-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"DETECTLANGUAGE in Google Sheets\" width=\"650\" height=\"370\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The syntax for the second function is <code>GOOGLETRANSLATE(text, from_language, to_language)<\/code> where you can use a cell reference or the text for the first argument. For the language arguments, you use a two-letter abbreviation. You can also use \u201cauto\u201d for the <code>from_language<\/code> argument to automatically detect the source dialect.<\/p>\n<p>To translate the text in cell A1 from English to Spanish, use this formula:<\/p>\n<pre>=GOOGLETRANSLATE(A1,\"en\",\"es\")<\/pre>\n<p>To translate a certain phrase to Spanish using auto-detect, you can use this formula:<\/p>\n<pre>=GOOGLETRANSLATE(\"Hello\",\"auto\",\"es\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795943\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/GOOGLETRANSLATE-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"GOOGLETRANSLATE in Google Sheets\" width=\"650\" height=\"316\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Greater_Than_Less_Than_and_Equal_to_GT_GTE_LT_LTE_EQ\"><\/span>Greater Than, Less Than, and Equal to: GT, GTE, LT, LTE, EQ<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Have you ever wanted an easy way to display if one value is greater than, less than, or equal to another in your sheet? These functions do just that and would be great additions to Excel.<\/p>\n<ul>\n<li><strong>GT<\/strong>: Greater Than, syntax <code>GT(value1, value2)<\/code><\/li>\n<li><strong>GTE<\/strong>: Greater Than or Equal to, syntax <code>GTE(value1, value2)<\/code><\/li>\n<li><strong>LT<\/strong>: Less Than, syntax <code>LT(value1, value2)<\/code><\/li>\n<li><strong>LTE<\/strong>: Less Than or Equal to, syntax <code>LTE(value1, value2)<\/code><\/li>\n<li><strong>EQ<\/strong>: Equal to, syntax <code>EQ(value1, value2)<\/code><\/li>\n<\/ul>\n<p>The formula for each function returns a True or False result. For instance, if <code>value1<\/code> is greater than <code>value2<\/code>, you\u2019ll receive the True result. If not, you\u2019ll receive False.<\/p>\n<p>To see if the value in cell A1 is greater than the one in cell A2, you would use this formula:<\/p>\n<pre>=GT(A1,A2)<\/pre>\n<p>To see if the first inserted value is greater than the second, you\u2019d use the following formula:<\/p>\n<pre>=GT(4,5)<\/pre>\n<p>To see if the value in cell A1 is greater than the inserted value, you can use this formula:<\/p>\n<pre>=GT(A1,5)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795948\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/GREATERTHAN-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"GREATER THAN function in Google Sheets\" width=\"650\" height=\"97\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_and_Customize_a_Picture_IMAGE\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_4\">Insert and Customize a Picture: IMAGE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Along with numbers and text, you may want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/764451\/how-to-insert-a-picture-in-microsoft-excel\/\">include an image in your spreadsheet. While you can easily insert an image in Google Sheets, the IMAGE function lets you insert one from the web and then customize its size.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Insert a Picture in Microsoft Excel<\/em><\/strong><\/p>\n<p>The syntax for the function is <code>IMAGE(url, mode, height, width)<\/code> where only the first argument is required. Here are the options you can use for the mode argument:<\/p>\n<ul>\n<li><strong>1<\/strong>: Fit the image within the cell and maintain the aspect ratio. This is the default mode.<\/li>\n<li><strong>2<\/strong>: Stretch or squeeze the image to fit within the cell without maintaining the aspect ratio.<\/li>\n<li><strong>3<\/strong>: Keep the image at its original size.<\/li>\n<li><strong>4<\/strong>: Use a custom size by entering the <code>height<\/code> and <code>width<\/code> arguments in pixels.<\/li>\n<\/ul>\n<p>To insert an image from the web and keep the original size, you would use this formula replacing the URL with your own:<\/p>\n<pre>=IMAGE(\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/DateOptions-GoogleSheetsCustomDateTime.png\",3)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795947\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/IMAGEOriginal-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMAGE function with original size\" width=\"650\" height=\"164\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To insert that same image but use a custom size, you would use this formula replacing the URL, width, and height with your own details:<\/p>\n<pre>=IMAGE(\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/02\/DateOptions-GoogleSheetsCustomDateTime.png\",4,200,500)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795946\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/IMAGECustom-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IMAGE function with custom size\" width=\"650\" height=\"153\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Another great way to use the IMAGE function is to create a QR code in Google Sheets!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a QR Code in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_a_Mini_Graph_SPARKLINE\"><\/span>Add a Mini Graph: SPARKLINE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You don\u2019t always need a chart that\u2019s bigger than life in your spreadsheet. Google Sheets allows you to add a mini chart using the SPARKLINE function.\u00a0In Excel, you can\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/howto\/16759\/how-to-use-sparklines-in-excel-2010\/\">create a sparkline\u00a0using the chart feature, but the function is simpler and faster to whip up.<\/p>\n<p>The syntax is <code>SPARKLINE(data, customizations)<\/code> where only the first argument is required. To customize the graph with the second argument, such as selecting the chart type, adding color, fine-tuning the axes, and more, check out our tutorial for creating a sparkline in Google Sheets.<\/p>\n<p>To add a basic sparkline with data from the cell range B2 through E2, you would use this formula:<\/p>\n<pre>=SPARKLINE(B2:E2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795945\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SPARKLINELine-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SPARKLINE Line chart\" width=\"650\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To use a bar chart with that same cell range, you\u2019d use this formula:<\/p>\n<pre>=SPARKLINE(B2:E2,{\"charttype\",\"column\"})<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795944\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SPARKLINEColumn-GoogleSheetsFunctionsNotExcel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SPARKLINE Column chart\" width=\"650\" height=\"151\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For even more functions you\u2019ll find in Google Sheets but not Microsoft Excel, look at how to join text or how to do the reverse and split text.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Concatenate Data from Multiple Cells in Google Sheets<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/795930\/google-sheets-functions-that-microsoft-excel-needs\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;14 Google Sheets Functions That Microsoft Excel Needs&#8221; Tada Images\/Shutterstock.com Microsoft Excel is a full-featured, commonly used spreadsheet application, but it\u2019s not perfect. Its longtime rival Google Sheets offers features that Excel does not, including many helpful functions. Let\u2019s take a look! This list isn\u2019t all-inclusive, and Excel could add one or more of these&#8230;<\/p>\n","protected":false},"author":1,"featured_media":442289,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/microsoft-excel-google-sheets-app-icons.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-442288","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/442288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=442288"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/442288\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/442289"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=442288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=442288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=442288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}