{"id":1320,"date":"2019-05-17T14:53:05","date_gmt":"2019-05-17T08:23:05","guid":{"rendered":"http:\/\/khub.phandeeyar.org\/docs\/google-toolkit\/useful-google-functions\/"},"modified":"2019-08-08T15:31:30","modified_gmt":"2019-08-08T09:01:30","slug":"useful-google-functions","status":"publish","type":"docs","link":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/","title":{"rendered":"Useful Google Sheet Functions"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_22 ez-toc-wrap-left counter-hierarchy counter-decimal ez-toc-transparent\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" style=\"display: none;\"><i class=\"ez-toc-glyphicon ez-toc-icon-toggle\"><\/i><\/a><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#VLOOKUP\" title=\"VLOOKUP\">VLOOKUP<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Small_letter_and_add\" title=\"Small letter and add (-)\">Small letter and add (-)<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#IMPORTRANGE\" title=\"IMPORTRANGE\">IMPORTRANGE<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#FILTER\" title=\"FILTER\">FILTER<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#TRANSPOSE\" title=\"TRANSPOSE\">TRANSPOSE<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#ARRAYFORMULA\" title=\"ARRAYFORMULA\">ARRAYFORMULA<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#GOOGLETRANSLATE\" title=\"GOOGLETRANSLATE\">GOOGLETRANSLATE<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#DATEDIF\" title=\"DATEDIF\">DATEDIF<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#IMAGES\" title=\"IMAGES\">IMAGES<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Auto-increment_number\" title=\"Auto-increment number\">Auto-increment number<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Importrange\" title=\"Importrange\">Importrange<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Average\" title=\"Average\">Average<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Join_TextShe\" title=\"Join TextShe\">Join TextShe<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Linebreak\" title=\"Linebreak\">Linebreak<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Unique\" title=\"Unique\">Unique<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#REGEXMATCH\" title=\"REGEXMATCH\">REGEXMATCH<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#Highlight_Duplicates\" title=\" Highlight Duplicates\"> Highlight Duplicates<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1016\u103c\u100a\u1037\u103a\u1010\u1032\u1037 sheet \u1010\u1005\u103a\u1001\u102f\u1011\u1000\u103a\u1015\u102d\u102f\u1015\u103c\u102e\u1038 \u1021\u1001\u103c\u102c\u1038 \u1021\u1019\u103b\u102c\u1038\u1000\u103c\u102e\u1038\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b Use cases \u1010\u103d\u1031\u1015\u103c\u1031\u102c\u1015\u103c\u101b\u1019\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1018\u1031\u1037\u1005\u103a\u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b Dashboard \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u1015\u103c\u102e\u1038 Analytics \u1010\u103d\u1031\u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b Information management system \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037\u101c\u100a\u103a\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b  \u1021\u1032\u1012\u102e\u101c\u102d\u102f \u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1016\u102d\u102f\u1037 \u1021\u1010\u103d\u1000\u103a recipe \u1010\u103d\u1031\u1010\u1031\u102c\u1037\u101c\u102d\u102f\u1010\u102c\u1015\u1031\u102b\u1037\u104b \u1018\u101a\u103a\u101c\u102d\u102f recipe \u1010\u103d\u1031\u101c\u1032\u1006\u102d\u102f\u1010\u1031\u102c\u1037 Formula \u1010\u103d\u1031\u104a App script \u1010\u103d\u1031 \u104a add-ons \u1010\u103d\u1031\u104a App script \u1000\u1010\u1031\u102c\u1037 \u1014\u100a\u103a\u1038\u1014\u100a\u103a\u1038\u1015\u102d\u102f\u1021\u1006\u1004\u1037\u103a\u1019\u103c\u1004\u1037\u103a\u1015\u102b\u1010\u101a\u103a\u104b Formula \u1010\u103d\u1031 addon \u1010\u103d\u1031\u1000\u1010\u1031\u102c\u1037 \u101e\u102c\u1019\u102c\u1014\u103a \u1000\u103b\u103d\u1019\u103a\u1038\u1000\u103b\u1004\u103a\u101e\u1030\u1010\u1005\u103a\u1026\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u101c\u1031\u102c\u1000\u103a\u1021\u1031\u102c\u1004\u103a \u1021\u1006\u1004\u103a\u1015\u103c\u1031\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u1001\u102f \u1021\u101e\u102f\u1036\u1038\u101d\u1004\u103a\u1010\u1032\u1037 Google Sheet formula \u1010\u103d\u1031\u1021\u1000\u103c\u1031\u102c\u1004\u103a\u1038 \u1000\u102d\u200c\u102f\u1015\u103c\u1031\u102c\u1015\u103c\u1015\u1031\u1038\u1019\u101a\u103a\u104b<\/p>\n\n\n\n<h4 id=\"vlookup\"><span class=\"ez-toc-section\" id=\"VLOOKUP\"><\/span>VLOOKUP<a href=\"#vlookup\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Vlookup function \u1000\u1010\u1031\u102c\u1037 \u1021\u101e\u102f\u1036\u1038\u1021\u1019\u103b\u102c\u1038\u1006\u102f\u1036\u1038\u1015\u1032\u104b \u101e\u1030\u1000 Sheet \u1010\u1005\u103a\u1001\u102f\u1000 Data \u1000\u102d\u102f \u1021\u1001\u103c\u102c\u1038\u1010\u1005\u103a\u1001\u102f\u1011\u1032\u1019\u103e\u102c\u101a\u1030\u1015\u103c\u1001\u103b\u1004\u103a\u101b\u1004\u103a\u101e\u102f\u1036\u1038\u1010\u101a\u103a\u104b \u1025\u1015\u1019\u102c \u1000\u103b\u103d\u1014\u103a\u1010\u1031\u102c\u103a\u1000 Sheet A \u1019\u103e\u102c ID \u1014\u1032\u1037 Name \u1006\u102d\u102f\u1015\u103c\u102e\u1038 Column \u1014\u103e\u1005\u103a\u1001\u102f\u101b\u103e\u102d\u1010\u101a\u103a\u104b Sheet B \u1019\u103e\u102c ID \u1014\u1036\u1015\u1010\u103a\u1010\u103d\u1031\u1011\u100a\u1037\u103a\u1011\u102c\u1038\u1010\u101a\u103a\u104b \u1012\u102b\u1015\u1031\u1019\u101a\u1037\u103a \u1018\u101a\u103a ID \u1000 \u1014\u102c\u1019\u100a\u103a \u1018\u101a\u103a\u101e\u1030\u101c\u1032\u101e\u102d\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u104b \u1012\u102b\u1006\u102d\u102f\u101b\u1004\u103a Vlookup formula \u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b\n\u101e\u1030\u1037 Formula \u1000\u1010\u1031\u102c\u1037<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>=VLOOKUP(cells to lookup, cells to reference, index of the cells to find, False)<\/p><\/blockquote>\n\n\n\n<h4 id=\"small-letter-and-add\"><span class=\"ez-toc-section\" id=\"Small_letter_and_add\"><\/span>Small letter and add (-)<a href=\"#small-letter-and-add\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1005\u102c\u101c\u102f\u1036\u1038\u1021\u1000\u103c\u102e\u1038\u1014\u1032\u1037\u101b\u1031\u1038\u1011\u102c\u1038\u1010\u1032\u1037 \u1014\u102c\u1019\u100a\u103a\u1010\u102d\u102f\u1037 \u1019\u103c\u102d\u102f\u1037\u1010\u102d\u102f\u1037\u1000\u102d\u102f \u1005\u102c\u101c\u102f\u1036\u1038\u1021\u101e\u1031\u1038\u1016\u103c\u1005\u103a\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u1015\u103c\u102e\u1038 space \u1010\u103d\u1031\u1014\u1031\u101b\u102c\u1019\u103e\u102c &#8211; \u1010\u103d\u1031\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u1032\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a \u1012\u102e Formula \u1000\u102d\u102f \u1021\u101c\u103d\u101a\u103a\u1010\u1000\u1030 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a \u104b <\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>=LOWER(SUBSTITUTE(A2,&#8221; &#8220;,&#8221;-&#8220;))<\/p><\/blockquote>\n\n\n\n<h4 id=\"importrange\"><span class=\"ez-toc-section\" id=\"IMPORTRANGE\"><\/span><strong>IMPORTRANGE<\/strong><a href=\"#importrange\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Importrange \u1000\u101c\u100a\u103a\u1038 \u1012\u1031\u1010\u102c\u1010\u103d\u1031\u1000\u102d\u102f sheet \u1010\u1005\u103a\u1001\u102f\u1000\u1014\u1031 \u1010\u1005\u103a\u1001\u102f\u1000\u102d\u102f \u101c\u100a\u103a\u1038\u1001\u1031\u102b\u103a\u1015\u103c\u1010\u102c\u1015\u1032\u104b \u1012\u102b\u1015\u1031\u1019\u101a\u1037\u103a Sheet \u1010\u1005\u103a\u1001\u102f\u1011\u1032\u1019\u103e\u102c\u101b\u103e\u102d\u1010\u1032\u1037 Workbook \u1010\u103d\u1031\u1021\u1001\u103b\u1004\u103a\u1038\u1001\u103b\u1004\u103a\u1038\u1019\u101f\u102f\u1010\u103a\u1015\u1032\u104b \u1016\u102d\u102f\u1004\u103a\u1014\u103e\u1005\u103a\u1001\u102f\u1000\u103d\u1032\u1014\u1031\u1010\u102c\u1000\u102d\u200c\u102f\u1010\u1031\u102c\u1004\u103a\u1019\u103e \u1012\u1031\u1010\u102c \u1015\u102d\u102f\u1037\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b File 1 \u1000\u200c \u1012\u1031\u1010\u102c\u1000\u102d\u102f File 2 \u1011\u1032\u101c\u103e\u1019\u103a\u1038\u1015\u102d\u102f\u1037\u1019\u101a\u103a\u1006\u102d\u102f\u1015\u102b\u1006\u102d\u102f\u1037 \u104b \u101e\u102f\u1036\u1038\u101b\u1010\u1032\u1037 Funtion \u1000<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>=IMPORTRANGE(&#8220;https:\/\/docs.google.com\/spreadsheets\/d\/abcd123abcd123&#8221;, &#8220;sheet1!A1:C10&#8221;)<\/p><\/blockquote>\n\n\n\n<p>Importrange \u1006\u102d\u102f\u1010\u1032\u1037\u1005\u102c\u101b\u1031\u1038\u1015\u103c\u102e\u1038\u101b\u1004\u103a \u1014\u1031\u102c\u1000\u103a\u1000 <a href=\"https:\/\/docs.google.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.google.com<\/a> address \u1000\u1010\u1031\u102c\u1037 \u1000\u102d\u102f\u101a\u103a\u1012\u1031\u1010\u102c\u101c\u102d\u102f\u1001\u103b\u1004\u103a\u1010\u1032\u1037 sheet \u101b\u1032\u1037\u101c\u102d\u1015\u103a\u1005\u102c\u1015\u102b\u104b \u1014\u1031\u102c\u1000\u103a\u1010\u1031\u102c\u1037 \u101e\u1030\u1037\u1011\u1032\u1019\u103e\u102c\u1015\u102b\u1010\u1032\u1037 \u1018\u101a\u103a sheet \u1000 \u1018\u101a\u103a Cell range \u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1000\u102d\u102f\u101b\u103d\u1031\u1038\u1015\u1031\u1038\u101b\u1015\u102b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<h4 id=\"filter\"><span class=\"ez-toc-section\" id=\"FILTER\"><\/span>FILTER<a href=\"#filter\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Data \u1010\u103d\u1031\u1000\u102d\u102f \u1005\u102e\u1005\u1005\u103a\u1015\u103c\u102e\u1038\u1015\u103c\u1001\u103b\u1004\u103a\u1010\u1032\u1037\u1021\u1001\u102b\u1019\u103b\u102d\u102f\u1038\u1010\u103d\u1031\u1019\u103e\u102c\u1021\u101e\u102f\u1036\u1038\u101d\u1004\u103a\u1010\u101a\u103a\u104a Sheet A \u1019\u103e\u102c \u101c\u1030\u1014\u102c\u1010\u103d\u1031\u101b\u1032\u1037 ID \u1014\u1036\u1015\u1010\u103a\u1014\u1032\u1037 \u101e\u1030\u1010\u1005\u103a\u1001\u1031\u102b\u1000\u103a \u1006\u1031\u1038\u1001\u1014\u103a\u1038\u101c\u102c\u1010\u102d\u102f\u1004\u103a\u1038 \u1005\u1005\u103a\u1006\u1031\u1038\u1010\u1032\u1037 \u1021\u1001\u103b\u1000\u103a\u1021\u101c\u1000\u103a\u1010\u103d\u1031\u101b\u103e\u102d\u1010\u101a\u103a\u1006\u102d\u102f\u1015\u102b\u1005\u102d\u102f\u1037\u104b\u101c\u1030\u1014\u102c\u1010\u103d\u1031\u1000\u1010\u1031\u102c\u1037 \u1021\u1019\u103b\u102c\u1038\u1000\u103c\u102e\u1038\u1016\u103c\u1005\u103a\u101c\u102d\u1019\u1037\u103a\u1019\u101a\u103a\u104b ID \u1010\u103d\u1031\u1000\u1021\u1019\u103b\u102c\u1038\u1000\u103c\u102e\u1038\u104b Sheet B \u1019\u103e\u102c \u1010\u1031\u102c\u1037 ID \u1014\u1036\u1015\u1010\u103a\u101b\u102d\u102f\u1000\u103a\u1011\u100a\u1037\u103a\u101c\u102d\u102f\u1000\u103a\u1010\u102c\u1014\u1032\u1037 \u1021\u1032\u1012\u102e\u101c\u1030\u1014\u102c\u101b\u1032\u1037 \u1006\u1031\u1038\u1001\u1014\u103a\u1038\u101c\u102c\u1010\u1032\u1037\u1021\u1001\u1031\u102b\u1000\u103a\u1010\u102d\u102f\u1004\u103a\u1038\u1019\u103e\u102c \u1005\u1005\u103a\u1010\u1032\u1037 \u1021\u1001\u103b\u1000\u103a\u1021\u101c\u1000\u103a\u1010\u103d\u1031\u1000\u102d\u102f\u1014\u1031\u1037\u1021\u101c\u102d\u102f\u1000\u103a\u1000\u103c\u100a\u1037\u103a\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Filter function \u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><code>=FILTER(range, condition1, [condition2, ...])<\/code><\/p><\/blockquote>\n\n\n\n<p>Filter \u1014\u1031\u102c\u1000\u103a\u1019\u103e\u102c range \u1000\u1010\u1031\u102c\u1037 \u1000\u102d\u102f\u101a\u103a\u1000\u103c\u100a\u1037\u103a\u1001\u103b\u1004\u103a\u1010\u1032\u1037 Sheet A \u101b\u1032\u1037 Column\u1010\u103d\u1031\u1000\u102d\u102f\u101e\u1010\u103a\u1019\u103e\u1010\u103a\u1015\u1031\u1038\u1010\u101a\u103a\u104b Condition \u1019\u103e\u102c\u1010\u1031\u102c\u1037 Sheet B \u1019\u103e\u102c\u101b\u103e\u102d\u1010\u1032\u1037 ID \u1000\u102d\u102f\u101b\u103d\u1031\u1038\u1015\u1031\u1038\u101c\u102d\u102f\u1000\u103a\u1015\u1031\u102b\u1037 \u104b \u1012\u102b\u1006\u102d\u102f\u101b\u1004\u103a Sheet A \u1011\u1032\u1019\u103e\u102c Sheet B \u1019\u103e\u102c\u101b\u103e\u102d\u1010\u1032\u1037 ID \u1014\u1032\u1037\u1010\u1030\u1010\u102c\u1010\u103d\u1031\u1037\u101b\u1004\u103a \u101b\u101c\u1012\u103a\u1010\u103d\u1031\u1000\u102d\u102f \u1015\u103c\u1015\u1031\u1038\u101c\u102d\u1019\u1037\u103a\u1019\u101a\u103a\u104b<\/p>\n\n\n\n<h4 id=\"transpose\"><span class=\"ez-toc-section\" id=\"TRANSPOSE\"><\/span>TRANSPOSE<a href=\"#transpose\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1012\u102b\u101c\u1031\u1038\u1000\u1010\u1031\u102c\u103a\u1010\u1031\u102c\u103a\u1021\u101e\u102f\u1036\u1038\u1000\u103b\u1015\u102b\u1010\u101a\u103a\u104b \u200cSheet A \u1000 \u1012\u1031\u1010\u102c\u1000 column \u101c\u102d\u102f\u1000\u103a\u1016\u103c\u1005\u103a\u1014\u1031\u1019\u101a\u103a\u1015\u1031\u102b\u1037\u104b Sheet B \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u101b\u103d\u103e\u1031\u1037\u1010\u1032\u1037\u1021\u1001\u102b\u1019\u103e\u102c Row \u101c\u102d\u102f\u1000\u103a\u1015\u103c\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Transpose \u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b <\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><code>Function \u1000\u1010\u1031\u102c\u1037 =Transpose() <\/code><\/p><\/blockquote>\n\n\n\n<p>\u1000\u103d\u1004\u103a\u1038\u1005\u1000\u103d\u1004\u103a\u1038\u1015\u102d\u1010\u103a\u1011\u1032\u1019\u103e\u102c\u1010\u1031\u102c\u1037 \u1000\u102d\u102f\u101a\u103a\u101e\u102f\u1036\u1038\u1001\u103b\u1004\u103a\u1010\u1032\u1037\u1021\u1001\u103c\u102c\u1038\u1016\u1031\u102c\u103a\u1019\u103b\u1030\u101c\u102c\u1000\u102d\u102f\u1011\u100a\u1037\u103a\u101b\u1010\u101a\u103a\u104b \u1021\u1032\u1012\u102e Formula \u1000\u102d\u102f\u1019\u103e \u1015\u102f\u1036\u1005\u1036\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u1015\u103c\u102e\u1038 \u1015\u103c\u1015\u1031\u1038\u101c\u102d\u1019\u1037\u103a\u1019\u101a\u103a\u104b\u1021\u1015\u1031\u102b\u103a\u1019\u103e\u102c\u1015\u102b\u1010\u1032\u1037 Filter function \u1000\u1011\u103d\u1000\u103a\u101c\u102c\u1010\u102c\u1010\u103d\u1031\u1000\u102d\u102f \u1015\u102f\u1036\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u1015\u103c\u101b\u1004\u103a\u1021\u1006\u1004\u103a\u1015\u103c\u1031\u1010\u102c\u1015\u1031\u102b\u1037\u104b\n\n<\/p>\n\n\n\n<h4 id=\"arrayformula\"><span class=\"ez-toc-section\" id=\"ARRAYFORMULA\"><\/span>ARRAYFORMULA<a href=\"#arrayformula\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1012\u102e\u1000\u1031\u102c\u1004\u103a\u1000\u102d\u102f\u200c\u1010\u1031\u102c\u1037 \u1000\u103b\u103d\u1014\u103a\u1010\u1031\u102c\u103a\u1021\u1000\u103c\u102d\u102f\u1000\u103a\u1006\u102f\u1036\u1038\u1015\u1032\u104b  \u101e\u1030\u1000 Formula \u1010\u103d\u1031\u1000\u102d\u102f cell \u1010\u102d\u102f\u1004\u103a\u1038\u1019\u103e\u102c\u101c\u102d\u102f\u1000\u103a\u1016\u103c\u100a\u1037\u103a\u1005\u101b\u102c\u1019\u101c\u102d\u102f\u1021\u1031\u102c\u1004\u103a\u101c\u102f\u1015\u103a\u1015\u1031\u1038\u1010\u101a\u103a\u104b \u1025\u1015\u1019\u102c \u1021\u1015\u1031\u102b\u103a\u1019\u103e\u102c\u1015\u103c\u1010\u1032\u1037 ID \u1010\u1005\u103a\u1001\u102f\u1010\u103d\u1031\u1037\u101b\u1004\u103a\u1014\u102c\u1019\u100a\u103a \u1015\u103c\u1010\u1032\u1037 function \u1000\u102d\u102f Row \u1010\u102d\u102f\u1004\u103a\u1038\u1019\u103e\u102c\u101c\u102d\u102f\u1000\u103a \u1016\u103c\u100a\u1037\u103a\u101b\u1019\u101c\u102d\u102f\u1016\u103c\u1005\u103a\u1014\u1031\u1010\u101a\u103a\u1006\u102d\u102f\u1015\u102b\u1005\u102d\u102f\u1037\u104b Row 1 \u1011\u1032\u1019\u103e\u102c \u1015\u1032 formula \u1010\u1005\u103a\u1001\u102f\u1011\u100a\u1037\u103a\u1015\u103c\u102e\u1038 \u101e\u1030\u1037\u1021\u1031\u102c\u1000\u103a\u1019\u103e\u102c\u101b\u103e\u102d\u1010\u1032\u1037 \u101f\u102c\u1010\u103d\u1031\u1019\u103e\u102c \u1021\u101c\u102d\u102f\u1021\u101c\u103b\u1031\u102c\u1000\u103a \u1006\u1000\u103a\u1016\u103c\u100a\u1037\u103a\u101e\u103d\u102c\u1038\u1021\u1031\u102c\u1004\u103a\u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><code>=ArrayFormula(IF(ROW(A:A)=1,\"Patient's Name\",IF(ISBLANK(A:A),\"\",Vlookup(A:A,'patient profile'!A:B,2,FALSE))))<\/code><\/p><\/blockquote>\n\n\n\n<h4 id=\"googletranslate\"><span class=\"ez-toc-section\" id=\"GOOGLETRANSLATE\"><\/span>GOOGLETRANSLATE<a href=\"#googletranslate\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1018\u102c\u101e\u102c\u1015\u103c\u1014\u103a\u1015\u1031\u1038\u1010\u1032\u1037 function \u1006\u102d\u102f\u1010\u102c\u1015\u103c\u1031\u102c\u1005\u101b\u102c\u1010\u1031\u102c\u1004\u103a\u1019\u101c\u102d\u102f\u1018\u1030\u1038\u104b Sheet \u101b\u1032\u1037function \u1011\u1032\u1019\u103e\u102c =Googletranslate() \u101c\u102d\u102f\u1037\u101b\u102d\u102f\u1000\u103a\u101c\u102d\u102f\u1000\u103a\u1010\u102c\u1014\u1032\u1037 \u101e\u1030\u1000\u1018\u101a\u103a\u101c\u102d\u102f\u101e\u102f\u1036\u1038\u101b\u1019\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1015\u103c\u1031\u102c\u1015\u103c\u101c\u102d\u1019\u1037\u103a\u1019\u101a\u103a\u104b \u1010\u1031\u102c\u103a\u1010\u1031\u102c\u103a \u1019\u102d\u102f\u1000\u103a\u1010\u101a\u103a\u104b \u1000\u102d\u102f\u101a\u103a\u1015\u103c\u1014\u103a\u1001\u103b\u1004\u103a\u1010\u1032\u1037 cell \u1010\u1031\u103d\u1000\u102d\u102f \u101b\u1031\u103d\u1038\u1015\u1031\u1038 \u1015\u103c\u102e\u1038\u101b\u1004\u103a \u101e\u1030\u1037\u1014\u1031\u102c\u1000\u103a\u1000 \u1018\u102clanugauge \u1014\u1032\u1037\u101b\u1031\u1038\u1011\u102c\u1038\u1010\u102c\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u101b\u103d\u1031\u1038\u1015\u1031\u1038\u101b\u1010\u101a\u103a\u104b \u1015\u103c\u102e\u1038\u101b\u1004\u103a\u1010\u1031\u102c\u1037 \u1000\u102d\u102f\u101a\u103a\u1015\u103c\u1014\u103a\u1001\u103b\u1004\u103a\u1010\u1032\u1037 language \u1000\u102d\u102f\u101b\u103d\u1031\u1038\u1015\u1031\u1038\u101b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><code>=GOOGLETRANSLATE(text, [source_language, target_language])<\/code><\/p><\/blockquote>\n\n\n\n<h4 id=\"datedif\"><span class=\"ez-toc-section\" id=\"DATEDIF\"><\/span>DATEDIF<a href=\"#datedif\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1012\u102b\u1000\u102d\u102f \u1010\u1031\u102c\u1037\u1021\u1001\u103b\u102d\u1014\u103a\u1010\u103d\u1031 \u1010\u103d\u1000\u103a\u1010\u1032\u1037\u1021\u1001\u102b \u1019\u103e\u102c\u1010\u1031\u102c\u103a\u1010\u1031\u102c\u103a\u1021\u101e\u102f\u1036\u1038\u101d\u1004\u103a\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b \u1025\u1015\u1019\u102c \u1021\u101e\u1000\u103a\u1018\u101a\u103a\u101c\u1031\u102c\u1000\u103a\u101b\u103e\u102d\u1015\u103c\u102e\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1000\u102d\u102f \u1019\u103d\u1031\u1038\u1014\u1031\u1037\u1000\u1014\u1031\u1010\u1005\u103a\u1006\u1004\u1037\u103a \u101e\u102d\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u1006\u102d\u102f\u1015\u102b\u1005\u102d\u102f\u1037\u104b \u101c\u1000\u103a\u101b\u103e\u102d \u101b\u1031\u102c\u1000\u103a\u1014\u1031\u1010\u1032\u1037 \u101b\u1000\u103a\u1011\u1032\u1000\u1014\u1031 \u1019\u103d\u1031\u1038\u101e\u1000\u1039\u1000\u101b\u102c\u1007\u103a\u1000\u102d\u102f \u1014\u103e\u102f\u1010\u103a\u1019\u103e\u102c\u1015\u1031\u102b\u1037\u104b\u200b\u1021\u1032\u1012\u102e\u1021\u1010\u103d\u1000\u103a \u1021\u1006\u1004\u103a\u101e\u1004\u1037\u103a\u101c\u102f\u1015\u103a\u1011\u102c\u1038\u1010\u1032\u1037 formula \u101b\u103e\u102d\u1015\u102b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>=<code>DATEDIF(start date,TOday(),\"Y\")<\/code><\/p><\/blockquote>\n\n\n\n<p>Start date, End Date \u1015\u103c\u102e\u1038\u1010\u1031\u102c\u1037 \u1014\u1031\u102c\u1000\u103a\u1000 \u101a\u1030\u1014\u1005\u103a\u101c\u102d\u102f\u1000\u103a\u1010\u101a\u103a\u200b\u104b\u200b\u101a\u1030\u1014\u1005\u103a\u1000\u1010\u1031\u102c\u1037 Y&#8221;,&#8221;M&#8221;,&#8221;D&#8221;,&#8221;MD&#8221;,&#8221;YM&#8221;,&#8221;YD&#8221;. \u1005\u1010\u102c\u1010\u1031\u103d\u1016\u103c\u1005\u103a\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b Y \u1000 Year, M \u1000 Month \u104a\u200bD \u1000 Day \u1015\u1031\u102b\u1037 \u104a  \u1012\u102b\u1000\u102d\u102f \u1021\u1001\u103c\u102c\u1038\u101e\u1031\u102c \u1021\u1001\u103b\u102d\u1014\u103a\u1019\u103b\u102d\u102f\u1038\u1005\u102f\u1036\u1021\u1010\u103d\u1000\u103a\u101c\u100a\u103a\u1038\u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u101e\u1031\u1038\u1010\u101a\u103a\u104b\n\n<\/p>\n\n\n\n<h4 id=\"images\"><span class=\"ez-toc-section\" id=\"IMAGES\"><\/span>IMAGES<a href=\"#images\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Google Sheet \u1011\u1032\u1019\u103e\u102c Image \u1010\u103d\u1031\u101c\u100a\u103a\u1038\u1011\u100a\u1037\u103a\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b \u1021\u1001\u103b\u102d\u102f\u1037\u1000\u1010\u1031\u102c\u1037 \u1019\u1000\u103c\u102d\u102f\u1000\u103a\u1000\u103c\u1018\u1030\u1038\u104b Image \u1010\u103d\u1031\u1000\u1021\u1000\u103c\u102e\u1038\u1000\u103c\u102e\u1038\u1010\u1031\u103d Sheet \u1010\u1005\u103a\u1001\u102f\u101c\u102f\u1036\u1038\u1000\u102d\u102f \u1016\u102f\u1036\u1038\u101e\u103d\u102c\u1038\u1010\u101a\u103a\u101c\u102d\u102f\u1037\u1006\u102d\u102f\u1000\u103c\u1010\u101a\u103a\u104b \u1012\u102b\u1015\u1031\u1019\u101a\u1037\u103a \u1021\u1032\u1012\u102e\u1011\u100a\u1037\u103a\u1011\u102c\u1038\u1010\u1032\u1037\u1015\u102f\u1036\u101c\u1031\u1038\u1010\u103d\u1031\u1000\u102d\u102f Cell \u101b\u1032\u1037\u1021\u101b\u103d\u101a\u103a\u1014\u1032\u1037\u1000\u103d\u1000\u103a\u1010\u102d\u1016\u103c\u1005\u103a\u1021\u1031\u102c\u1004\u103a\u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b  \u1012\u102e\u1019\u103e\u102c\u1016\u1010\u103a\u1000\u103c\u100a\u1037\u103a\u1015\u102b\u104b\u200bFormula \u1000\u1010\u1031\u102c\u1037 \u1021\u1031\u102c\u1000\u103a\u1015\u102b\u1021\u1010\u102d\u102f\u1004\u103a\u1038 \u1015\u1032 \u104b <\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><code>=IMAGE(\"URL\") or =IMAGE(\"URL\", 1)<\/code><\/p><\/blockquote>\n\n\n\n<p>Image \u1014\u1031\u102c\u1000\u103a\u1000 () \u1011\u1032\u1019\u103e\u102c Image \u101b\u1032\u1037 Address \u1000\u102d\u102f\u1011\u100a\u1037\u103a\u1015\u1031\u1038\u1015\u102b\u104b\u200b \u101e\u1030\u1037\u1014\u1031\u102c\u1000\u103a \u1000 1,2,3,4 \u1011\u100a\u1037\u103a\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a. \u1010\u1005\u103a\u1001\u102f\u1005\u102e\u1005\u1019\u103a\u1038\u1000\u103c\u100a\u1037\u103a\u1015\u103c\u102e\u1038 \u1018\u101a\u103a\u101c\u102d\u102f\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u1032\u101e\u103d\u102c\u1038\u101c\u1032\u1000\u103c\u100a\u1037\u103a\u1000\u103c\u100a\u1037\u103a\u1015\u1031\u102b\u1037\u104b<\/p>\n\n\n\n<h4 id=\"auto-increment-number\"><span class=\"ez-toc-section\" id=\"Auto-increment_number\"><\/span>Auto-increment number<a href=\"#auto-increment-number\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u1021\u101c\u102d\u102f\u1021\u101c\u103b\u1031\u102c\u1000\u103a Google sheet \u1019\u103e\u102c\u1014\u1036\u1015\u102b\u1010\u103a\u1010\u103d\u1031\u1016\u103c\u100a\u1037\u103a\u1016\u102d\u102f\u1037\u1006\u102d\u102f\u101b\u1004\u103a \u1012\u102e Formula \u1000\u102d\u102f\u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<p>\u200b<code>=ArrayFormula(IF(ROW(B:B)=1,\"no ID\",IF(ISBLANK(B:B),\"\",0+row(B2:B)-2)))\n\n<\/code><\/p>\n\n\n\n<h4 id=\"import\"><span class=\"ez-toc-section\" id=\"Importrange\"><\/span>Importrange<a href=\"#import\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Import function \u1000\u102d\u102f Sheet \u1010\u1005\u103a\u1001\u102f\u1021\u1010\u103d\u1004\u103a\u1038\u1019\u103e\u102c\u1016\u103c\u1005\u103a\u1005\u1031\u104a Google sheet \u1010\u1005\u103a\u1001\u102f\u1000\u1014\u1031 \u1014\u1031\u102c\u1000\u103a\u1010\u1005\u103a\u1001\u102f\u1000\u102d\u102f \u1016\u103c\u1005\u103a\u1005\u1031 \u1012\u1031\u1010\u102c\u1010\u103d\u1031\u101c\u103e\u1019\u103a\u1038\u1015\u102d\u102f\u1037\u1010\u1032\u1037\u1021\u1001\u102b\u1019\u103e\u102c \u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u1015\u102b\u1010\u101a\u103a\u104b \u101e\u1030\u1037\u1000\u102d\u102f \u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u1001\u103c\u1004\u103a\u1038\u1016\u103c\u1004\u103a\u1037 File A \u1019\u103e\u102c \u1015\u103c\u102f\u101c\u102d\u102f\u1000\u103a\u1015\u103c\u1004\u103a\u101c\u102d\u102f\u1000\u103a\u1010\u1032\u1037\u1021\u101b\u102c\u1010\u103d\u1031\u1021\u102c\u1038\u101c\u102f\u1036\u1038\u1000 File B \u1019\u103e\u102c \u1021\u1031\u102c\u103a\u1010\u102d\u102f \u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u1032\u101e\u103d\u102c\u1038\u1010\u102c\u1019\u103b\u102d\u102f\u1038\u1016\u103c\u1005\u103a\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b\u200bImport \u1000\u102d\u102f\u101e\u102f\u1036\u1038\u1019\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Google Sheet formula bar \u1014\u1031\u101b\u102c\u1019\u103e\u102c =Importrange \u1006\u102d\u102f\u1015\u103c\u102e\u1038\u101b\u102d\u102f\u1000\u103a\u1010\u102c\u1014\u1032\u1037\u1014\u1031\u102c\u1000\u103a\u1000 \u1011\u1015\u103a\u101b\u102d\u102f\u1000\u103a\u101b\u1019\u101a\u103a\u1037\u1005\u102c\u1010\u103d\u1031\u1000\u102d\u102f hint \u1015\u1031\u1038\u1015\u102b\u101c\u102d\u1019\u103a\u1037\u1019\u101a\u103a\u104b  &#8221; &#8221; \u1011\u1032\u1015\u102b\u1010\u102c\u1000\u1010\u1031\u102c\u1037 address \u1015\u102b\u104b \u1021\u1032\u1012\u102e address \u1000\u102d\u102f \u1021\u1001\u103c\u102c\u1038 file \u101b\u1032\u1037 address bar \u1000\u1014\u1031 \u101e\u103d\u102c\u1038\u101a\u1030\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u1032\u1012\u102e\u1014\u1031\u102c\u1000\u103a , \u1001\u1036\u1010\u101a\u103a\u104b\u200b\u101e\u1030\u1037\u1014\u1031\u102c\u1000\u103a\u1019\u103e\u102c\u101c\u102d\u102f\u1000\u103a\u1010\u102c\u1000 &#8220;\u1021\u1032\u1012\u102e\u1016\u102d\u102f\u1004\u103a\u1011\u1032\u1019\u103e\u102c\u1015\u102b\u1010\u1032\u1037 sheet \u101b\u1032\u1037\u1014\u102c\u1019\u100a\u103a\u104b \u1015\u103c\u102e\u1038\u1010\u1031\u102c\u1037 Column \u1014\u102c\u1019\u100a\u103a\u1010\u103d\u1031\u1015\u102b\u104b\u200b&#8221; \u1015\u1011\u1019\u1005\u1005\u1001\u103c\u1004\u103a\u1038\u1019\u103e\u102c\u101e\u1030\u1000 access \u1010\u1031\u102c\u1004\u103a\u1038\u1010\u1032\u1037 box \u101c\u1031\u1038\u1015\u1031\u102b\u103a\u101c\u102c\u101c\u102d\u1019\u103a\u1037\u1019\u101a\u103a\u104b \u1021\u1032\u1012\u102b\u1000\u102d\u102f \u1014\u103e\u102d\u1015\u103a\u1015\u1031\u1038\u101b\u1004\u103a \u1012\u1031\u1010\u102c\u1010\u103d\u1031\u1005\u101b\u1031\u102c\u1000\u103a\u101c\u102c\u1015\u102b\u101c\u102d\u1019\u103a\u1037\u1019\u101a\u103a\u104b<\/p>\n\n\n\n<p><code>=IMPORTRANGE(\"https:\/\/docs.google.com\/spreadsheets\/d\/abcd123abcd123\", \"sheet1!A1:C10\")<\/code><\/p>\n\n\n\n<h4 id=\"average\"><span class=\"ez-toc-section\" id=\"Average\"><\/span>Average<a href=\"#average\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<h4 id=\"join-textshe\"><span class=\"ez-toc-section\" id=\"Join_TextShe\"><\/span>Join TextShe<a href=\"#join-textshe\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<h4 id=\"linebreak\"><span class=\"ez-toc-section\" id=\"Linebreak\"><\/span>Linebreak<a href=\"#linebreak\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Google sheet \u1011\u1032\u1019\u103e\u102c Linebreak\u1010\u103d\u1031\u1000\u102d\u102f \u1018\u101a\u103a\u101c\u102d\u102f\u101b\u103e\u102c\u1019\u101c\u1032\u104b \u1012\u102b\u1019\u103e\u1019\u101f\u102f\u1010\u103a \u101b\u103e\u102d\u1010\u1032\u1037 , \u1010\u102d\u102f\u1037 &#8211; \u1010\u102d\u102f\u1037\u1000\u102d\u102f Line break \u1021\u1016\u103c\u1005\u103a\u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u1032\u1001\u103b\u1004\u103a\u101b\u1004\u103a\u1018\u101a\u103a\u101c\u102d\u102f\u101c\u102f\u1015\u103a\u1019\u101c\u1032\u104b \u1021\u1032\u1012\u102e\u1021\u1010\u103d\u1000\u103a \u101e\u102e\u1038\u101e\u1014\u1037\u103a Function \u1010\u1031\u102c\u1037\u1019\u101b\u103e\u102d\u1015\u102b\u1018\u1030\u1038\u104b \u1012\u102b\u1015\u1031\u1019\u101a\u1037\u103a \u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1010\u1032\u1037\u1014\u100a\u103a\u1038\u1010\u1031\u102c\u1037\u101b\u103e\u102d\u1010\u101a\u103a\u104b \u1021\u1032\u1012\u102b\u1000\u1010\u1031\u102c\u1037 specia character \u1010\u103d\u1031\u1000\u102d\u102f\u101e\u102f\u1036\u1038\u1010\u102c\u1015\u102b\u104b\u200b\u101c\u102d\u102f\u1004\u103a\u1038\u1018\u101b\u102d\u1010\u103a\u1021\u1010\u103d\u1000\u103a Char(10) \u1000\u102d\u102f\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b Function \u1021\u1014\u1031\u1014\u1032\u1037\u1006\u102d\u102f\u101b\u1004\u103a\u1010\u1031\u102c\u1037 \u1021\u1031\u102c\u1000\u103a\u1015\u102b \u1016\u1031\u102c\u103a\u1019\u103b\u102f\u101c\u102c\u1000\u102d\u102f\u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b \u101e\u1030\u1006\u102d\u102f\u101c\u102d\u102f\u1010\u102c\u1000\u1010\u1031\u102c\u1037 A1 \u1011\u1032\u1019\u103e\u102c \u1015\u102b\u1010\u1032\u1037 , \u1000\u102d\u102f char(10) \u1014\u1032\u1037\u1021\u1005\u102c\u1038\u1011\u102d\u102f\u1038\u1001\u102d\u102f\u1004\u103a\u1038\u1010\u102c\u1015\u102b\u104b \u1012\u102b\u1000\u102d\u102f\u1019\u102d\u1019\u102d\u1005\u102d\u1010\u103a\u1000\u103c\u102d\u102f\u1000\u103a\u1015\u103c\u1014\u103a\u1015\u103c\u1004\u103a\u101b\u1031\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b<\/p>\n\n\n\n<p> <code>=SUBSTITUTE(A1, \",\", char(10))<\/code><\/p>\n\n\n\n<h4 id=\"unique\"><span class=\"ez-toc-section\" id=\"Unique\"><\/span>Unique<a href=\"#unique\"><\/a><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Unique Function \u1006\u102d\u102f\u1010\u102c Google Sheet \u1011\u1032\u1019\u103e\u102c\u1015\u102b\u1010\u1032\u1037 Function \u1010\u1005\u103a\u1001\u102f\u1016\u103c\u1005\u103a\u1015\u102b\u1010\u101a\u103a\u104b Duplicate \u1016\u103c\u1005\u103a\u1014\u1031\u1010\u1032\u1037 Row\u1010\u103d\u1031\u1000\u102d\u102f \u1016\u101a\u103a\u101b\u103e\u102c\u1038\u1001\u103b\u1004\u103a\u1010\u1032\u1037\u1021\u1001\u102b\u101e\u102f\u1036\u1038\u1014\u102d\u102f\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b \u1016\u1031\u102c\u103a\u1019\u103b\u1030\u101c\u102c\u1000\u1010\u1031\u102c\u1037 <code>= UNIQUE(\u1000\u102d\u102f\u101a\u103a\u101e\u1010\u103a\u1019\u103e\u1010\u103a\u1001\u103b\u1004\u103a\u1010\u1032\u1037 Range)<\/code> \u1016\u103c\u1005\u103a\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u1000\u103c\u1036\u1015\u103c\u102f\u101c\u102d\u102f\u1010\u102c\u1000\u1010\u1031\u102c\u1037 UNIQUE \u1000\u102d\u102f\u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u1001\u103b\u1004\u103a\u101b\u1004\u103a \u1021\u1001\u103c\u102c\u1038 Sheet \u1010\u1005\u103a\u1001\u102f\u1000\u102d\u102f\u1016\u103d\u1004\u1037\u103a\u1015\u103c\u102e\u1038\u1010\u1031\u102c\u1037\u1019\u103e \u1021\u1032\u1012\u102d\u1011\u1032\u1019\u103e\u102c\u101e\u103d\u102c\u1038\u101e\u102f\u1036\u1038\u1005\u1031\u1001\u103b\u1004\u103a\u1015\u102b\u1010\u101a\u103a\u104b Duplicate \u1016\u101a\u103a\u101b\u103e\u102c\u1038\u101e\u101c\u102d\u102f\u1019\u103b\u102d\u102f\u1038\u101c\u1000\u103a\u101b\u103e\u102d sheet \u1019\u103e\u102c\u1015\u1032 \u1010\u1014\u103a\u1038 \u1015\u103c\u1031\u102c\u1004\u103a\u1038\u101c\u1032\u101e\u103d\u102c\u1038\u1010\u102c\u1019\u103b\u102d\u102f\u1038\u1019\u101f\u102f\u1010\u103a\u1015\u102b\u1018\u1030\u1038\u104b<\/p>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"REGEXMATCH\"><\/span>REGEXMATCH<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Column \u1010\u1005\u103a\u1001\u102f\u1001\u102f\u1011\u1032\u1019\u103e\u102c \u1019\u102d\u1019\u102d \u101c\u102d\u102f\u1001\u103b\u1004\u103a\u1010\u1032\u1037 \u1005\u102c\u101c\u102f\u1036\u1038\u1000\u102d\u102f\u101b\u103e\u102c\u1016\u102d\u102f\u1037\u1021\u1010\u103d\u1000\u103a \u1012\u102e Formula \u1000\u102d\u102f\u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u1015\u102b\u1010\u101a\u103a\u104b =REGEXMATCH(&#8220;Spreadsheets&#8221;, &#8220;S.r&#8221;) \u1000\u1010\u1031\u102c\u1037 \u1012\u102e\u1000\u102f\u1010\u103a\u1000\u102d\u102f\u1018\u101a\u103a\u101c\u102d\u102f\u101e\u102f\u1036\u1038\u101b\u1019\u101c\u1032\u1006\u102d\u102f\u1010\u102c\u1015\u103c\u1031\u102c\u1015\u102b\u1010\u101a\u103a\u104b &nbsp;<br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac\" alt=\"\"\/><\/figure>\n\n\n\n<h4><span class=\"ez-toc-section\" id=\"Highlight_Duplicates\"><\/span> Highlight Duplicates<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Column \u1010\u1005\u103a\u1001\u102f\u1010\u100a\u103a\u1038\u1019\u103e\u102c \u1010\u1030\u1014\u1031\u1010\u1032\u1037 \u1010\u1014\u103a\u1016\u102d\u102f\u1038\u1010\u103d\u1031\u1000\u102d\u102f \u1021\u101b\u1031\u102c\u1004\u103a\u1014\u1032\u1037\u1001\u103d\u1032\u1015\u103c\u1001\u103b\u1004\u103a\u1010\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a \u1012\u102e\u1014\u100a\u103a\u1038\u101c\u1019\u103a\u1038\u1000\u102d\u102f\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u101b\u1004\u103a\u1006\u102f\u1036\u1038 \u1010\u1030\u1010\u102c\u1010\u103d\u1031\u101b\u103e\u102c\u1001\u103b\u1004\u103a\u1010\u1032\u1037 \u1000\u1031\u102c\u103a\u101c\u1036 \u1000\u102d\u102f select \u1019\u103e\u1010\u103a\u1015\u103c\u102e\u1038 right click \u1014\u103e\u102d\u1015\u103a conditional formation \u1000\u102d\u102f \u101c\u102f\u1015\u103a\u1015\u1031\u1038\u101b\u1015\u102b\u1019\u101a\u103a\u104b \u1021\u1032\u1012\u102e\u1014\u1031\u102c\u1000\u103a\u1010\u1031\u102c\u1037 \u1010\u103d\u1031\u1037\u1010\u1032\u1037\u1011\u1032\u1000 format rules \u1011\u1032\u1000\u102d\u102f\u101e\u103d\u102c\u1038 \u1021\u1031\u102c\u1000\u103a\u1006\u102f\u1036\u1038\u1019\u103e\u102c formula \u1000\u102d\u102f\u1011\u100a\u103a\u1037\u1015\u1031\u1038\u101b\u1015\u102b\u1019\u101a\u103a.\u104b \u1011\u100a\u103a\u1037\u101b\u1010\u1032\u1037 formula \u1000\u1010\u1031\u102c\u1037 <\/p>\n\n\n\n<p>=countif(A:A,A1)>1 \u1006\u102d\u102f\u1015\u103c\u102e\u1038\u1016\u103c\u1005\u103a\u1015\u102b\u1010\u101a\u103a\u104b \u1012\u102e\u1014\u1031\u101b\u102c\u1019\u103e\u102c A:A \u1000\u102d\u102f \u1019\u102d\u1019\u102d\u101b\u103d\u1031\u1038\u1011\u102c\u1038\u1010\u1032\u1037 column \u101b\u1032\u1037 \u1014\u1036\u1015\u102b\u1010\u103a\u1000\u102d\u102f\u1011\u100a\u1037\u103a\u101b\u1015\u102b\u1019\u101a\u103a\u104b\u200b\u1025\u1015\u1019\u102c Column B \u1006\u102d\u102f\u101b\u1004\u103a countif(B:B,B1)>1 \u1006\u102d\u102f\u1015\u103c\u102e\u1038\u1016\u103c\u1005\u103a\u1015\u102b\u1019\u101a\u103a\u104b\u200b Column C \u1006\u102d\u102f\u101b\u1004\u103a =countif(C:C,C1)>1 \u1016\u103c\u1005\u103a\u1015\u102b\u1019\u101a\u103a\u104b <\/p>\n<div class=\"fb-background-color\">\n\t\t\t  <div \n\t\t\t  \tclass = \"fb-comments\" \n\t\t\t  \tdata-href = \"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/\"\n\t\t\t  \tdata-numposts = \"10\"\n\t\t\t  \tdata-lazy = \"true\"\n\t\t\t\tdata-colorscheme = \"light\"\n\t\t\t\tdata-order-by = \"social\"\n\t\t\t\tdata-mobile=true>\n\t\t\t  <\/div><\/div>\n\t\t  <style>\n\t\t    .fb-background-color {\n\t\t\t\tbackground:  !important;\n\t\t\t}\n\t\t\t.fb_iframe_widget_fluid_desktop iframe {\n\t\t\t    width: 100% !important;\n\t\t\t}\n\t\t  <\/style>\n\t\t  ","protected":false},"featured_media":0,"parent":2148,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Useful Google Sheet Functions -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Useful Google Sheet Functions -\" \/>\n<meta property=\"og:description\" content=\"Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1016\u103c\u100a\u1037\u103a\u1010\u1032\u1037 sheet \u1010\u1005\u103a\u1001\u102f\u1011\u1000\u103a\u1015\u102d\u102f\u1015\u103c\u102e\u1038 \u1021\u1001\u103c\u102c\u1038 \u1021\u1019\u103b\u102c\u1038\u1000\u103c\u102e\u1038\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b Use cases \u1010\u103d\u1031\u1015\u103c\u1031\u102c\u1015\u103c\u101b\u1019\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1018\u1031\u1037\u1005\u103a\u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b Dashboard \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u1015\u103c\u102e\u1038 Analytics \u1010\u103d\u1031\u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b Information management system \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037\u101c\u100a\u103a\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b \u1021\u1032\u1012\u102e\u101c\u102d\u102f \u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1016\u102d\u102f\u1037 \u1021\u1010\u103d\u1000\u103a recipe \u1010\u103d\u1031\u1010\u1031\u102c\u1037\u101c\u102d\u102f\u1010\u102c\u1015\u1031\u102b\u1037\u104b \u1018\u101a\u103a\u101c\u102d\u102f recipe \u1010\u103d\u1031\u101c\u1032\u1006\u102d\u102f\u1010\u1031\u102c\u1037 Formula \u1010\u103d\u1031\u104a App script \u1010\u103d\u1031 \u104a add-ons \u1010\u103d\u1031\u104a App script \u1000\u1010\u1031\u102c\u1037 \u1014\u100a\u103a\u1038\u1014\u100a\u103a\u1038\u1015\u102d\u102f\u1021\u1006\u1004\u1037\u103a\u1019\u103c\u1004\u1037\u103a\u1015\u102b\u1010\u101a\u103a\u104b Formula \u1010\u103d\u1031 addon \u1010\u103d\u1031\u1000\u1010\u1031\u102c\u1037 \u101e\u102c\u1019\u102c\u1014\u103a \u1000\u103b\u103d\u1019\u103a\u1038\u1000\u103b\u1004\u103a\u101e\u1030\u1010\u1005\u103a\u1026\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u101c\u1031\u102c\u1000\u103a\u1021\u1031\u102c\u1004\u103a \u1021\u1006\u1004\u103a\u1015\u103c\u1031\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u1001\u102f [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/phandeeyar\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-08T09:01:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@phandeeyar\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#organization\",\"name\":\"Phandeeyar\",\"url\":\"https:\/\/drnyeinchan.com\/khub\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/phandeeyar\/\",\"https:\/\/www.facebook.com\/phandeeyar\",\"https:\/\/twitter.com\/phandeeyar\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/drnyeinchan.com\/khub\/wp-content\/uploads\/2019\/05\/21586512_1605500346167861_245298389276563305_o.png\",\"contentUrl\":\"https:\/\/drnyeinchan.com\/khub\/wp-content\/uploads\/2019\/05\/21586512_1605500346167861_245298389276563305_o.png\",\"width\":1200,\"height\":1200,\"caption\":\"Phandeeyar\"},\"image\":{\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#website\",\"url\":\"https:\/\/drnyeinchan.com\/khub\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/drnyeinchan.com\/khub\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#primaryimage\",\"url\":\"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac\",\"contentUrl\":\"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#webpage\",\"url\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/\",\"name\":\"Useful Google Sheet Functions -\",\"isPartOf\":{\"@id\":\"https:\/\/drnyeinchan.com\/khub\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#primaryimage\"},\"datePublished\":\"2019-05-17T08:23:05+00:00\",\"dateModified\":\"2019-08-08T09:01:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/drnyeinchan.com\/khub\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Toolkit\",\"item\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Google Sheet\",\"item\":\"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Useful Google Sheet Functions\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Useful Google Sheet Functions -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/","og_locale":"en_US","og_type":"article","og_title":"Useful Google Sheet Functions -","og_description":"Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1016\u103c\u100a\u1037\u103a\u1010\u1032\u1037 sheet \u1010\u1005\u103a\u1001\u102f\u1011\u1000\u103a\u1015\u102d\u102f\u1015\u103c\u102e\u1038 \u1021\u1001\u103c\u102c\u1038 \u1021\u1019\u103b\u102c\u1038\u1000\u103c\u102e\u1038\u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1015\u102b\u1010\u101a\u103a\u104b Use cases \u1010\u103d\u1031\u1015\u103c\u1031\u102c\u1015\u103c\u101b\u1019\u101a\u103a\u1006\u102d\u102f\u101b\u1004\u103a Google Sheet \u1000\u102d\u102f \u1012\u1031\u1010\u102c\u1018\u1031\u1037\u1005\u103a\u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b Dashboard \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037 \u1011\u102c\u1038\u1015\u103c\u102e\u1038 Analytics \u1010\u103d\u1031\u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u1010\u101a\u103a\u104b Information management system \u1010\u1005\u103a\u1001\u102f\u1021\u1014\u1031\u1014\u1032\u1037\u101c\u100a\u103a\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1010\u101a\u103a\u104b \u1021\u1032\u1012\u102e\u101c\u102d\u102f \u101c\u102f\u1015\u103a\u101c\u102d\u102f\u1037\u101b\u1016\u102d\u102f\u1037 \u1021\u1010\u103d\u1000\u103a recipe \u1010\u103d\u1031\u1010\u1031\u102c\u1037\u101c\u102d\u102f\u1010\u102c\u1015\u1031\u102b\u1037\u104b \u1018\u101a\u103a\u101c\u102d\u102f recipe \u1010\u103d\u1031\u101c\u1032\u1006\u102d\u102f\u1010\u1031\u102c\u1037 Formula \u1010\u103d\u1031\u104a App script \u1010\u103d\u1031 \u104a add-ons \u1010\u103d\u1031\u104a App script \u1000\u1010\u1031\u102c\u1037 \u1014\u100a\u103a\u1038\u1014\u100a\u103a\u1038\u1015\u102d\u102f\u1021\u1006\u1004\u1037\u103a\u1019\u103c\u1004\u1037\u103a\u1015\u102b\u1010\u101a\u103a\u104b Formula \u1010\u103d\u1031 addon \u1010\u103d\u1031\u1000\u1010\u1031\u102c\u1037 \u101e\u102c\u1019\u102c\u1014\u103a \u1000\u103b\u103d\u1019\u103a\u1038\u1000\u103b\u1004\u103a\u101e\u1030\u1010\u1005\u103a\u1026\u1038 \u101e\u102f\u1036\u1038\u101c\u102d\u102f\u1037\u101b\u1014\u102d\u102f\u1004\u103a\u101c\u1031\u102c\u1000\u103a\u1021\u1031\u102c\u1004\u103a \u1021\u1006\u1004\u103a\u1015\u103c\u1031\u1015\u102b\u1010\u101a\u103a\u104b \u1021\u1001\u102f [&hellip;]","og_url":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/","article_publisher":"https:\/\/www.facebook.com\/phandeeyar","article_modified_time":"2019-08-08T09:01:30+00:00","og_image":[{"url":"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac"}],"twitter_card":"summary_large_image","twitter_site":"@phandeeyar","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/drnyeinchan.com\/khub\/#organization","name":"Phandeeyar","url":"https:\/\/drnyeinchan.com\/khub\/","sameAs":["https:\/\/www.instagram.com\/phandeeyar\/","https:\/\/www.facebook.com\/phandeeyar","https:\/\/twitter.com\/phandeeyar"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/drnyeinchan.com\/khub\/#\/schema\/logo\/image\/","url":"https:\/\/drnyeinchan.com\/khub\/wp-content\/uploads\/2019\/05\/21586512_1605500346167861_245298389276563305_o.png","contentUrl":"https:\/\/drnyeinchan.com\/khub\/wp-content\/uploads\/2019\/05\/21586512_1605500346167861_245298389276563305_o.png","width":1200,"height":1200,"caption":"Phandeeyar"},"image":{"@id":"https:\/\/drnyeinchan.com\/khub\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/drnyeinchan.com\/khub\/#website","url":"https:\/\/drnyeinchan.com\/khub\/","name":"","description":"","publisher":{"@id":"https:\/\/drnyeinchan.com\/khub\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/drnyeinchan.com\/khub\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#primaryimage","url":"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac","contentUrl":"https:\/\/lh6.googleusercontent.com\/CT_4UitIB9sO7cmrE5XFvJw6mUJj4n-1927LdYhyGoCaobHr48wF4cJwA6jRHoN_sVdBmT6ptbtN2FxxIq_So7b_D0j9M1WCQwCfBtdXMfVReV_9E8GVGgiJdSh32YHN4sXSYCac"},{"@type":"WebPage","@id":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#webpage","url":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/","name":"Useful Google Sheet Functions -","isPartOf":{"@id":"https:\/\/drnyeinchan.com\/khub\/#website"},"primaryImageOfPage":{"@id":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#primaryimage"},"datePublished":"2019-05-17T08:23:05+00:00","dateModified":"2019-08-08T09:01:30+00:00","breadcrumb":{"@id":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/useful-google-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/drnyeinchan.com\/khub\/"},{"@type":"ListItem","position":2,"name":"Google Toolkit","item":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/"},{"@type":"ListItem","position":3,"name":"Google Sheet","item":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/"},{"@type":"ListItem","position":4,"name":"Useful Google Sheet Functions"}]}]}},"jetpack_likes_enabled":false,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs\/1320"}],"collection":[{"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/comments?post=1320"}],"version-history":[{"count":2,"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs\/1320\/revisions"}],"predecessor-version":[{"id":2521,"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs\/1320\/revisions\/2521"}],"up":[{"embeddable":true,"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs\/2148"}],"next":[{"title":"Google Sheet \u1010\u103d\u1004\u103a Google OCR \u1021\u101e\u102f\u1036\u1038\u1015\u103c\u102f\u1001\u103c\u1004\u103a\u1038","link":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/google-sheet\/google-sheet-%e1%80%90%e1%80%bd%e1%80%84%e1%80%ba-google-ocr-%e1%80%a1%e1%80%9e%e1%80%af%e1%80%b6%e1%80%b8%e1%80%95%e1%80%bc%e1%80%af%e1%80%81%e1%80%bc%e1%80%84%e1%80%ba%e1%80%b8\/","href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/docs\/1337"}],"wp:attachment":[{"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/media?parent=1320"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/drnyeinchan.com\/khub\/wp-json\/wp\/v2\/doc_tag?post=1320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}