{"id":6408,"date":"2021-03-03T21:26:08","date_gmt":"2021-03-03T20:26:08","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6408"},"modified":"2024-05-24T16:46:27","modified_gmt":"2024-05-24T14:46:27","slug":"top-excel-formulas-function-examples-to-get-better-at-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/","title":{"rendered":"101 Advanced Excel Formulas &#038; Functions Examples"},"content":{"rendered":"<p style=\"padding-left: 40px;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33515\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples-1024x576.png\" alt=\"101 Advanced Excel Formulas &amp; Functions Examples\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/03\/101-Advanced-Excel-Formulas-Functions-Examples.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><\/p>\n<p>Advanced <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/groupby-pivotby-image-functions\/\" target=\"_blank\" rel=\"noopener\">Excel Formulas &amp; Functions<\/a> are a <strong>must know feature in Microsoft Excel<\/strong> that allows you to quickly analyze your data in many forms.\u00a0 Once you learn how to construct Excel Formulas &amp; Functions, your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Excel skills<\/a> &amp; level will increase exponentially.<\/p>\n<p>Below you will find <strong>101 Excel formulas &amp; functions examples<\/strong> for key formulas &amp; functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more. You will also find Excel formulas with examples in Excel sheet free download!<\/p>\n<h3>See how easy it is to learn the Top Excel Formulas here&#8230;<\/h3>\n<h3>Formulas VS Functions<\/h3>\n<p>You most probably have heard the words Formulas &amp; Functions both being used in Excel. What is the difference between them?<\/p>\n<p>A <strong>Formula<\/strong> is an expression which calculates the value of a cell and a <strong>Function<\/strong> is a predefined formula that is made available for you to use in Excel.\u00a0 Below is an example of both but we use both terms (Formulas &amp; Functions) interchangeably:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples-14155.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14155 size-full\" title=\"101 Advanced Excel Formulas &amp; Functions Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples-14155.jpg\" alt=\"101 Advanced Excel Formulas &amp; Functions Examples\" width=\"445\" height=\"245\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples-14155.jpg 445w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples-14155-300x165.jpg 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14156\" title=\"101 Advanced Excel Formulas &amp; Functions Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples.jpg\" alt=\"101 Advanced Excel Formulas &amp; Functions Examples\" width=\"445\" height=\"244\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples.jpg 445w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/11\/Top-Excel-Formulas-amp-Function-Examples-300x164.jpg 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/a><\/p>\n<div>\n<div>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"IRPP_minimalist\"><span style=\"display: block; padding-left:1em; padding-right:1em;\"><span class=\"ctaText\">Click Here To<\/span>&nbsp; <span class=\"postTitle\">&#x1f449; Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel LEVEL!<\/span><\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#List_of_101_Advanced_Excel_Formulas_Functions_Examples\" title=\"List of 101 Advanced Excel Formulas &amp; Functions Examples\">List of 101 Advanced Excel Formulas &amp; Functions Examples<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#3D\" title=\"3D\u00a0\">3D\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#And\" title=\"And \">And <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Array\" title=\"Array\u00a0\">Array\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Array_Lookup\" title=\"Array, Lookup\u00a0\">Array, Lookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Average\" title=\"Average\u00a0\">Average\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Between\" title=\"Between\u00a0\">Between\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Chart\" title=\"Chart\u00a0\">Chart\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Clean\" title=\"Clean\u00a0\">Clean\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Concatenate\" title=\"Concatenate\u00a0\">Concatenate\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Convert_Values\" title=\"Convert, Values\u00a0\">Convert, Values\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Count\" title=\"Count\u00a0\">Count\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#CountA\" title=\"CountA\u00a0\">CountA\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#CountBlank\" title=\"CountBlank\u00a0\">CountBlank\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#CountIf\" title=\"CountIf\u00a0\">CountIf\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#CountIfs\" title=\"CountIfs\u00a0\">CountIfs\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Data_Cleansing_Trim\" title=\"Data Cleansing, Trim\u00a0\">Data Cleansing, Trim\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#DateDif\" title=\"DateDif\u00a0\">DateDif\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#EndOfMonth\" title=\"EndOfMonth\u00a0\">EndOfMonth\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Evaluate\" title=\"Evaluate\u00a0\">Evaluate\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Extract_Find_Left\" title=\"Extract, Find, Left\u00a0\">Extract, Find, Left\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Filter\" title=\"Filter \">Filter <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#FV\" title=\"FV\u00a0\">FV\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Find_Select\" title=\"Find &amp; Select\u00a0\">Find &amp; Select\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Hlookup\" title=\"Hlookup\u00a0\">Hlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#If\" title=\"If\u00a0\">If\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#If_And\" title=\"If, And\u00a0\">If, And\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Iferror\" title=\"Iferror\u00a0\">Iferror\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Iferror_Vlookup\" title=\"Iferror, Vlookup\u00a0\">Iferror, Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Index\" title=\"Index\u00a0\">Index\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Index_Match\" title=\"Index, Match\u00a0\">Index, Match\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Indirect\" title=\"Indirect\u00a0\">Indirect\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Left\" title=\"Left\u00a0\">Left\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Len_Length\" title=\"Len, Length\u00a0\">Len, Length\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Match\" title=\"Match\u00a0\">Match\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Mathematical_Formulas\" title=\"Mathematical Formulas\u00a0\">Mathematical Formulas\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Mod\" title=\"Mod\u00a0\">Mod\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Multiple_Criteria_Vlookup\" title=\"Multiple Criteria, Vlookup\u00a0\">Multiple Criteria, Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Offset\" title=\"Offset\u00a0\">Offset\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Percentage\" title=\"Percentage\u00a0\">Percentage\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Pivot_Table_GetPivotData\" title=\"Pivot Table, GetPivotData\u00a0\">Pivot Table, GetPivotData\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Proper\" title=\"Proper\u00a0\">Proper\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Rand\" title=\"Rand\u00a0\">Rand\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Randbetween\" title=\"Randbetween\u00a0\">Randbetween\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Reference\" title=\"Reference\u00a0\">Reference\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Remove\" title=\"Remove\u00a0\">Remove\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Remove_Substitute\" title=\"Remove, Substitute\u00a0\">Remove, Substitute\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Replace\" title=\"Replace\u00a0\">Replace\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Replace_Cleanup\" title=\"Replace, Cleanup\u00a0\">Replace, Cleanup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Right\" title=\"Right\u00a0\">Right\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Round\" title=\"Round\u00a0\">Round\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Show_Hide\" title=\"Show, Hide\u00a0\">Show, Hide\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Sort\" title=\"Sort\u00a0\">Sort\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Sortby\" title=\"Sortby\u00a0\">Sortby\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Substitute\" title=\"Substitute\u00a0\">Substitute\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Substitute_Trim\" title=\"Substitute, Trim\u00a0\">Substitute, Trim\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-57\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Subtotal\" title=\"Subtotal\u00a0\">Subtotal\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-58\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Sum_Lookup\" title=\"Sum, Lookup\u00a0\">Sum, Lookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-59\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Sumifs\" title=\"Sumifs\u00a0\">Sumifs\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-60\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Sumproduct\" title=\"Sumproduct\u00a0\">Sumproduct\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-61\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Text\" title=\"Text\u00a0\">Text\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-62\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Time\" title=\"Time\u00a0\">Time\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-63\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Transpose\" title=\"Transpose \">Transpose <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-64\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Type\" title=\"Type \">Type <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-65\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Upper\" title=\"Upper \">Upper <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-66\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Unique\" title=\"Unique \">Unique <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-67\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Value\" title=\"Value \">Value <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-68\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Vlookup\" title=\"Vlookup\u00a0\">Vlookup\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-69\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Xlookup\" title=\"Xlookup \">Xlookup <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-70\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Weekday\" title=\"Weekday\u00a0\">Weekday\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-71\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Weeknum\" title=\"Weeknum \">Weeknum <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-72\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Workday\" title=\"Workday\u00a0\">Workday\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-73\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/#Year\" title=\"Year \">Year <\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"List_of_101_Advanced_Excel_Formulas_Functions_Examples\"><\/span><span class=\"ui-provider a b c d e f g h i j k l m n o p q r s t u v w x y z ab ac ae af ag ah ai aj ak\" dir=\"ltr\"><strong>List of 101 Advanced Excel Formulas &amp; Functions Examples<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><br \/>\n<div class='content-column one_third'><p><span style=\"color: #000000 !important;\"><i class=\"fa fa-calendar \" ><\/i> <strong>DATE &amp; TIME<\/strong><\/span><br \/>\n<a href=\"#section1\">DateDif<\/a><br \/>\n<a href=\"#section2\">EndOfMonth<\/a><br \/>\n<a href=\"#section3\">Time<\/a><br \/>\n<a href=\"#section4\">Weekday<\/a><br \/>\n<a href=\"#section67\">Weeknum<\/a><br \/>\n<a href=\"#section5\">Workday<\/a><br \/>\n<a href=\"#section66\">Year<\/a><\/p>\n<p><span style=\"color: #000000 !important;\"><i class=\"fa fa-plus-circle \" ><\/i> <strong>LOGICAL<\/strong><\/span><br \/>\n<a href=\"#section65\">And<\/a><br \/>\n<a href=\"#section6\">If<\/a><br \/>\n<a href=\"#section7\">If, And<\/a><br \/>\n<a href=\"#section8\">Iferror<\/a><\/p>\n<p><span style=\"color: #000000 !important;\"><i class=\"fa fa-arrow-circle-up \" ><\/i>\u00a0<strong>LOOKUP<\/strong><\/span><br \/>\n<a href=\"#section9\">Array, Lookup<\/a><br \/>\n<a href=\"#section10\">Hlookup<\/a><br \/>\n<a href=\"#section11\">Iferror, Vlookup<\/a><br \/>\n<a href=\"#section12\">Index<\/a><br \/>\n<a href=\"#section13\">Index, Match<\/a><br \/>\n<a href=\"#section14\">Indirect<\/a><br \/>\n<a href=\"#section15\">Match<\/a><br \/>\n<a href=\"#section16\">Multiple Criteria, Vlookup<\/a><br \/>\n<a href=\"#section17\">Offset<\/a><br \/>\n<a href=\"#section18\">Pivot Table, GetPivotData<\/a><br \/>\n<a href=\"#section19\">Sum, Lookup<\/a><br \/>\n<a href=\"#section20\">Vlookup<\/a><br \/>\n<a href=\"#section72\">Xlookup<\/a><\/div><div class='content-column one_third'><p><span style=\"color: #000000 !important;\"><i class=\"fa fa-calculator \" ><\/i>\u00a0<strong>MATH<\/strong><\/span><br \/>\n<a href=\"#section21\">Average<\/a><br \/>\n<a href=\"#section22\">Count<\/a><br \/>\n<a href=\"#section23\">CountA<\/a><br \/>\n<a href=\"#section24\">CountBlank<\/a><br \/>\n<a href=\"#section25\">CountIf<\/a><br \/>\n<a href=\"#section26\">CountIfs<\/a><br \/>\n<a href=\"#section27\">Mathematical Formulas<\/a><br \/>\n<a href=\"#section28\">Mod<\/a><br \/>\n<a href=\"#section29\">Percentage<\/a><br \/>\n<a href=\"#section30\">Rand<\/a><br \/>\n<a href=\"#section31\">Randbetween<\/a><br \/>\n<a href=\"#section32\">Round<\/a><br \/>\n<a href=\"#section33\">Subtotal<\/a><br \/>\n<a href=\"#section34\">Sumifs<\/a><br \/>\n<a href=\"#section35\">Sumproduct<\/a><\/p>\n<p><span style=\"color: #000000 !important;\"><i class=\"fa fa-bars \" ><\/i> <strong>OTHER<\/strong><\/span><br \/>\n<a href=\"#section36\">3D<\/a><br \/>\n<a href=\"#section37\">Array<\/a><br \/>\n<a href=\"#section38\">Chart<\/a><br \/>\n<a href=\"#section39\">Convert, Values<\/a><br \/>\n<a href=\"#section40\">Evaluate<\/a><br \/>\n<a href=\"#section41\">Find &amp; Select<\/a><br \/>\n<a href=\"#section42\">FV<\/a><br \/>\n<a href=\"#section43\">Reference<\/a><br \/>\n<a href=\"#section44\">Show, Hide<\/a><br \/>\n<a href=\"#section71\">Transpose<\/a><br \/>\n<a href=\"#section70\">Type<\/a><br \/>\n<a href=\"#section68\">Value<\/a><\/div><div class='content-column one_third last_column'><p><span style=\"color: #000000 !important;\"><i class=\"fa fa-desktop \" ><\/i> <strong>TEXT<\/strong><\/span><br \/>\n<a href=\"#section45\">Between<\/a><br \/>\n<a href=\"#section46\">Clean<\/a><br \/>\n<a href=\"#section47\">Concatenate<\/a><br \/>\n<a href=\"#section48\">Data Cleansing, Trim<\/a><br \/>\n<a href=\"#section49\">Extract, Find, Left<\/a><br \/>\n<a href=\"#section50\">Left<\/a><br \/>\n<a href=\"#section51\">Len, Length<\/a><br \/>\n<a href=\"#section52\">Proper<\/a><br \/>\n<a href=\"#section53\">Remove<\/a><br \/>\n<a href=\"#section54\">Remove, Substitute<\/a><br \/>\n<a href=\"#section55\">Replace<\/a><br \/>\n<a href=\"#section56\">Replace, Cleanup<\/a><br \/>\n<a href=\"#section57\">Right<\/a><br \/>\n<a href=\"#section58\">Substitute<\/a><br \/>\n<a href=\"#section59\">Substitute, Trim<\/a><br \/>\n<a href=\"#section60\">Text<\/a><br \/>\n<a href=\"#section69\">Upper<\/a><\/p>\n<p><span style=\"color: #000000 !important;\"><i class=\"fa fa-desktop \" ><\/i> <strong>OFFICE 365<\/strong><\/span><br \/>\n<a href=\"#section61\">Filter<\/a><br \/>\n<a href=\"#section62\">Sort<\/a><br \/>\n<a href=\"#section63\">Sortby<\/a><br \/>\n<a href=\"#section64\">Unique<\/a><\/p><\/div><div class='clear_column'><\/div><br \/>\n<\/div>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n\n<p><!--<script type=\"text\/javascript\" src=\"https:\/\/lead.myexcelonline.com\/app\/js\/api.min.js\" data-campaign=\"f2q8uijmbbmwc3oohwuo\" data-user=\"52704\" async><\/script>--><\/p>\n<\/div>\n<\/div>\n<p>Click on any Excel formula &amp; function link below and it will take you to the advanced Excel formulas with examples in Excel sheet free download for you to practice!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"IRPP_minimalist\"><span style=\"display: block; padding-left:1em; padding-right:1em;\"><span class=\"ctaText\">Click Here To<\/span>&nbsp; <span class=\"postTitle\">&#x1f449; Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel LEVEL!<\/span><\/span><\/a><\/p>\n<\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"3D\"><\/span><span style=\"color: #ff0000;\"><a id=\"section36\"><\/a>3D\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/consolidate-with-3d-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Consolidate with 3D Formulas in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"And\"><\/span><span style=\"color: #ff0000;\"><a id=\"section65\"><\/a>And <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/and-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">AND Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Array\"><\/span><span style=\"color: #ff0000;\"><a id=\"section37\"><\/a>Array\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-total-sales-with-an-array-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate Total Sales With An Array Formula<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-array-formulas-explained\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Array Formulas Explained<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Array_Lookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section9\"><\/a>Array, Lookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/total-bonus-due-with-an-array-lookup-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Total Bonus Due With An Array Lookup Formula<\/a><\/div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Average\"><\/span><span style=\"color: #ff0000;\"><a id=\"section21\"><\/a>Average\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/get-average-values-excels-average-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Get the Average of Values with Excel\u2019s AVERAGE Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Between\"><\/span><span style=\"color: #ff0000;\"><a id=\"section45\"><\/a>Between\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/between-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">BETWEEN Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Chart\"><\/span><span style=\"color: #ff0000;\"><a id=\"section38\"><\/a>Chart\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/in-cell-bar-charts-with-the-excel-rept-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">In-Cell Bar Charts with the REPT Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Clean\"><\/span><span style=\"color: #ff0000;\"><a id=\"section46\"><\/a>Clean\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-excels-clean-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s CLEAN Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Concatenate\"><\/span><span style=\"color: #ff0000;\"><a id=\"section47\"><\/a>Concatenate\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Concatenate With A Line Break<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Convert_Values\"><\/span><span style=\"color: #ff0000;\"><a id=\"section39\"><\/a>Convert, Values\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-formulas-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Convert Formulas to Values<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Count\"><\/span><span style=\"color: #ff0000;\"><a id=\"section22\"><\/a>Count\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Count Formula in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CountA\"><\/span><span style=\"color: #ff0000;\"><a id=\"section23\"><\/a>CountA\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/counta-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountA Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CountBlank\"><\/span><span style=\"color: #ff0000;\"><a id=\"section24\"><\/a>CountBlank\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countblank-formula-excel-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountBlank Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CountIf\"><\/span><span style=\"color: #ff0000;\"><a id=\"section25\"><\/a>CountIf\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-formula-excel-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountIf Formula in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"CountIfs\"><\/span><span style=\"color: #ff0000;\"><a id=\"section26\"><\/a>CountIfs\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countifs-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CountIfs Formula in Excel<\/a><\/div>\n<\/div>\n<\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Data_Cleansing_Trim\"><\/span><span style=\"color: #ff0000;\"><a id=\"section48\"><\/a>Data Cleansing, Trim\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-the-trim-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s TRIM Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"DateDif\"><\/span><span style=\"color: #ff0000;\"><a id=\"section1\"><\/a>DateDif\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datedif-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">DATEDIF function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"EndOfMonth\"><\/span><span style=\"color: #ff0000;\"><a id=\"section2\"><\/a>EndOfMonth\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-endofmonth-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u00b4s EndOfMonth function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Evaluate\"><\/span><span style=\"color: #ff0000;\"><a id=\"section40\"><\/a>Evaluate\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/evaluate-formulas-step-by-step-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Evaluate Formulas Step By Step in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Extract_Find_Left\"><\/span><span style=\"color: #ff0000;\"><a id=\"section49\"><\/a>Extract, Find, Left\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-first-name-from-full-name-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extract First Name From Full Name in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Filter\"><\/span><span style=\"color: #ff0000;\"><a id=\"section61\"><\/a>Filter <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/filter-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">FILTER Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"FV\"><\/span><span style=\"color: #ff0000;\"><a id=\"section42\"><\/a>FV\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-compound-interest-excels-fv-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate the Compound Interest with Excel\u2019s FV Formula<\/a><\/div>\n<div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-monthly-investment-excels-fv-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate your Monthly Investment with Excel\u2019s FV Formula<\/a><\/div>\n<\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Find_Select\"><\/span><span style=\"color: #ff0000;\"><a id=\"section41\"><\/a>Find &amp; Select\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-all-excel-formula-cells\/\" target=\"_blank\" rel=\"noopener noreferrer\">Highlight All Excel Formula Cells<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Hlookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section10\"><\/a>Hlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/formula\/hlookup-function-excel-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">HLOOKUP Function in Excel: Introduction<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><!--<script type=\"text\/javascript\" src=\"https:\/\/lead.myexcelonline.com\/app\/js\/api.min.js\" data-campaign=\"f2q8uijmbbmwc3oohwuo\" data-user=\"52704\" async><\/script>--><\/p>\n<\/div>\n<\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"If\"><\/span><span style=\"color: #ff0000;\"><a id=\"section6\"><\/a>If\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">IF Function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"If_And\"><\/span><span style=\"color: #ff0000;\"><a id=\"section7\"><\/a>If, And\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-combined-with-the-and-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">IF Function Combined With The AND Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Iferror\"><\/span><span style=\"color: #ff0000;\"><a id=\"section8\"><\/a>Iferror\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/iferror-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">IFERROR Function: Introduction<\/a><\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Iferror_Vlookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section11\"><\/a>Iferror, Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-combine-vlookup-and-iferror-to-replace-the-n-a-error-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Combine VLOOKUP and IFERROR to Replace the #N\/A Error in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Index\"><\/span><span style=\"color: #ff0000;\"><a id=\"section12\"><\/a>Index\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX Function Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-with-data-validation\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX Function with Data Validation<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-a-range-using-the-index-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sum a Range Using the INDEX Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Index_Match\"><\/span><span style=\"color: #ff0000;\"><a id=\"section13\"><\/a>Index, Match\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-index-match-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Use INDEX-MATCH Formula<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-match-2-criteria-with-data-validation-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Match 2 Criteria with Data Validation<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-match-maximum-sales-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDEX-MATCH Maximum Sales<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Indirect\"><\/span><span style=\"color: #ff0000;\"><a id=\"section14\"><\/a>Indirect\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-indirect-function-using-sheet-references\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function Using Sheet References<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-for-dependent-dropdown-lists-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">INDIRECT Function for Dependent Dropdown Lists in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Left\"><\/span><span style=\"color: #ff0000;\"><a id=\"section50\"><\/a>Left\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extracting-data-with-excels-left-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extracting Data with Excel\u2019s LEFT Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Len_Length\"><\/span><span style=\"color: #ff0000;\"><a id=\"section51\"><\/a>Len, Length\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-length-of-text-with-excels-len-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Getting the length of text with Excel\u2019s LEN Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Match\"><\/span><span style=\"color: #ff0000;\"><a id=\"section15\"><\/a>Match\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-match-function-intro\/\" target=\"_blank\" rel=\"noopener noreferrer\">MATCH Function Intro<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/match-two-lists-with-the-match-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Match Two Lists With The MATCH Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Mathematical_Formulas\"><\/span><span style=\"color: #ff0000;\"><a id=\"section27\"><\/a>Mathematical Formulas\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/subtraction-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Subtraction Formula in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/division-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Division Formula in Excel<\/a><\/div>\n<div><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/addition-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Addition Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Mod\"><\/span><span style=\"color: #ff0000;\"><a id=\"section28\"><\/a>Mod\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-remainder-with-excels-mod-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Getting the remainder with Excel\u2019s MOD Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Multiple_Criteria_Vlookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section16\"><\/a>Multiple Criteria, Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-criteria-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP with Multiple Criteria in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Offset\"><\/span><span style=\"color: #ff0000;\"><a id=\"section17\"><\/a>Offset\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-dynamic-data-range-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Dynamic Data Range with the OFFSET function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-offset-function-introduced\/\" target=\"_blank\" rel=\"noopener noreferrer\">OFFSET Function Introduced<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/return-the-last-value-column-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Return the Last Value in a Column with the Offset Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-last-7-transactions-offset-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sum the Last 7 Transactions with the Offset Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Percentage\"><\/span><span style=\"color: #ff0000;\"><a id=\"section29\"><\/a>Percentage\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-percentage-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Calculate Percentage in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Pivot_Table_GetPivotData\"><\/span><span style=\"color: #ff0000;\"><a id=\"section18\"><\/a>Pivot Table, GetPivotData\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getpivotdata-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">GETPIVOTDATA Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Proper\"><\/span><span style=\"color: #ff0000;\"><a id=\"section52\"><\/a>Proper\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-excels-proper-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s PROPER Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Rand\"><\/span><span style=\"color: #ff0000;\"><a id=\"section30\"><\/a>Rand\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-random-list-ordering-with-excels-rand-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create a Random List with Excel\u2019s RAND Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Randbetween\"><\/span><span style=\"color: #ff0000;\"><a id=\"section31\"><\/a>Randbetween\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/randbetween-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">RANDBETWEEN Function<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/randbetween-function-for-dates\/\" target=\"_blank\" rel=\"noopener noreferrer\">RANDBETWEEN Function for Excel Dates<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Reference\"><\/span><span style=\"color: #ff0000;\"><a id=\"section43\"><\/a>Reference\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/jump-to-a-cell-reference-within-an-excel-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Jump To A Cell Reference Within An Excel Formula<\/a><\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Remove\"><\/span><span style=\"color: #ff0000;\"><a id=\"section53\"><\/a>Remove\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Formulas in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Remove_Substitute\"><\/span><span style=\"color: #ff0000;\"><a id=\"section54\"><\/a>Remove, Substitute\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-second-hyphen-with-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Remove Second Hyphen with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Replace\"><\/span><span style=\"color: #ff0000;\"><a id=\"section55\"><\/a>Replace\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-phone-area-codes-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Change Phone Area Codes with Excel\u2019s REPLACE Formula<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s REPLACE Formula<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extract-last-name-with-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extract Last Name with Excel\u2019s REPLACE Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Replace_Cleanup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section56\"><\/a>Replace, Cleanup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clear-everything-hyphen-excels-replace-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Clear Everything Before the Hyphen with Excel\u2019s REPLACE Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Right\"><\/span><span style=\"color: #ff0000;\"><a id=\"section57\"><\/a>Right\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extracting-data-with-excels-right-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Extracting Data with Excel\u2019s RIGHT Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Round\"><\/span><span style=\"color: #ff0000;\"><a id=\"section32\"><\/a>Round\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Round Off Numbers with Excel\u2019s ROUND Formula<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">10 + 1 Ways to Round Numbers in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Show_Hide\"><\/span><span style=\"color: #ff0000;\"><a id=\"section44\"><\/a>Show, Hide\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-show-hide-formulas-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Show &amp; Hide Formulas in Excel<\/a><\/div>\n<\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Sort\"><\/span><span style=\"color: #ff0000;\"><a id=\"section62\"><\/a>Sort\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">SORT Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Sortby\"><\/span><span style=\"color: #ff0000;\"><a id=\"section63\"><\/a>Sortby\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sortby-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">SORTBY Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Substitute\"><\/span><span style=\"color: #ff0000;\"><a id=\"section58\"><\/a>Substitute\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-comma-after-the-surname-with-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Comma After the Surname with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cleaning Data with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-text-occurrences-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Count Text Occurrences with Excel\u2019s SUBSTITUTE Formula<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Substitute_Trim\"><\/span><span style=\"color: #ff0000;\"><a id=\"section59\"><\/a>Substitute, Trim\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-remove-leading-and-trailing-spaces-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Leading and Trailing Spaces in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Subtotal\"><\/span><span style=\"color: #ff0000;\"><a id=\"section33\"><\/a>Subtotal\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/autosum-an-array-of-data-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Autosum an Array of Data in Excel<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-avoid-double-counting\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Avoid Double Counting<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-filtered-or-visible-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Filtered or Visible Values<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-subtotal-function-include-hidden-values\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Subtotal Function \u2013 Include Hidden Values<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/summarize-data-with-dynamic-subtotals-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Summarize Data With Dynamic Subtotals<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Sum_Lookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section19\"><\/a>Sum, Lookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/two-way-lookup-using-intersect-function-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Two Way Lookup Using The SUM Intersect Function<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Sumifs\"><\/span><span style=\"color: #ff0000;\"><a id=\"section34\"><\/a>Sumifs\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIF Function: Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-one-criteria-sum-range\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIF Function: One Criteria &amp; Sum Range<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIFS Function: Introduction<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-wildcards\/\" target=\"_blank\" rel=\"noopener noreferrer\">SUMIFS function: Wildcards *<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Sumproduct\"><\/span><span style=\"color: #ff0000;\"><a id=\"section35\"><\/a>Sumproduct\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-conditional-date\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Conditional Date<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-conditional-sum\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Conditional Sum<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-count\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Count<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-maximum-sales\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Maximum Sales<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-sum-multiple-criteria\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced SUMPRODUCT Function: Sum Multiple Criteria<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-sum-of-the-top-3-sales-with-an-array-formula\/\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumproduct-weighted-averages\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sumproduct &amp; Weighted Averages<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Text\"><\/span><span style=\"color: #ff0000;\"><a id=\"section60\"><\/a>Text\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-text-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u00b4s TEXT Function<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-leading-zeros-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Add Leading Zeros in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Time\"><\/span><span style=\"color: #ff0000;\"><a id=\"section3\"><\/a>Time\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/calculate-elapsed-time-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Calculate Elapsed Time in Excel<\/a><\/div>\n<div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Transpose\"><\/span><span style=\"color: #ff0000;\"><a id=\"section71\"><\/a>Transpose <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">TRANSPOSE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Type\"><\/span><span style=\"color: #ff0000;\"><a id=\"section70\"><\/a>Type <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/type-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">TYPE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Upper\"><\/span><span style=\"color: #ff0000;\"><a id=\"section69\"><\/a>Upper <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/upper-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">UPPER Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Unique\"><\/span><span style=\"color: #ff0000;\"><a id=\"section64\"><\/a>Unique <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unique-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">UNIQUE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Value\"><\/span><span style=\"color: #ff0000;\"><a id=\"section68\"><\/a>Value <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/value-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VALUE Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Vlookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section20\"><\/a>Vlookup\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-named-ranges-with-vlookup-formula-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Named Ranges with Vlookup Formula<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-approximate-match-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup Approximate Match in Excel<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Example: Vlookup with a Drop Down List<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-function-introduction-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Function: Introduction<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup in an Excel Table<\/a><\/div>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-multiple-excel-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup in Multiple Excel Sheets<\/a><\/div>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-columns\/\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP Multiple Columns<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Xlookup\"><\/span><span style=\"color: #ff0000;\"><a id=\"section72\"><\/a>Xlookup <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #f4f4f4;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-function-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to use the XLOOKUP function in Excel with 7 Examples!<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Weekday\"><\/span><span style=\"color: #ff0000;\"><a id=\"section4\"><\/a>Weekday\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/weekday-function-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">WEEKDAY function: Introduction<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Weeknum\"><\/span><span style=\"color: #ff0000;\"><a id=\"section67\"><\/a>Weeknum <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/weeknum-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">WEEKNUM Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Workday\"><\/span><span style=\"color: #ff0000;\"><a id=\"section5\"><\/a>Workday\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/workday-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Workday Formula in Excel<\/a><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Year\"><\/span><span style=\"color: #ff0000;\"><a id=\"section66\"><\/a>Year <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<div style=\"background: #e8e8e8;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/year-formula-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">YEAR Formula in Excel<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"IRPP_minimalist\"><span style=\"display: block; padding-left:1em; padding-right:1em;\"><span class=\"ctaText\">Click Here To<\/span>&nbsp; <span class=\"postTitle\">&#x1f449; Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel LEVEL!<\/span><\/span><\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Advanced Excel Formulas &amp; Functions are a must know feature in Microsoft Excel that allows you to quickly analyze your data in many forms.\u00a0 Once you learn how to construct Excel Formulas &amp; Functions, your Excel skills &amp; level will increase exponentially. Below you will find 101 Excel formulas &amp; functions examples for key formulas [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":33515,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"101 Advanced Excel Formulas & Functions Examples","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[115,13,3,15,12,11,16,14],"tags":[43,257],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6408"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6408"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6408\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33515"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}