{"id":262318,"date":"2024-05-05T11:50:23","date_gmt":"2024-05-05T11:50:23","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=262318"},"modified":"2024-05-05T11:50:23","modified_gmt":"2024-05-05T11:50:23","slug":"how-to-find-the-percentile-in-excel-starting-with-the-highest-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/","title":{"rendered":"How to find the percentile in Excel starting with the highest value?"},"content":{"rendered":"<p>Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset, which helps in understanding the distribution of values. By default, Excel calculates percentiles starting with the lowest value. However, there might be scenarios where you would like to find percentiles starting with the highest value. In this article, we will guide you on how to achieve that.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey 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\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#The_ANSWER_to_the_question_%E2%80%9CHow_to_find_the_percentile_in_Excel_starting_with_the_highest_value%E2%80%9D\" title=\"The ANSWER to the question &#8220;How to find the percentile in Excel starting with the highest value?&#8221;\">The ANSWER to the question &#8220;How to find the percentile in Excel starting with the highest value?&#8221;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#1_What_is_a_percentile_in_Excel\" title=\"1. What is a percentile in Excel?\">1. What is a percentile in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#2_How_does_Excel_calculate_percentiles\" title=\"2. How does Excel calculate percentiles?\">2. How does Excel calculate percentiles?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#3_How_is_PERCENTRANKEXC_different_from_PERCENTILEEXC\" title=\"3. How is PERCENTRANK.EXC different from PERCENTILE.EXC?\">3. How is PERCENTRANK.EXC different from PERCENTILE.EXC?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#4_What_is_the_formula_for_finding_percentiles_in_Excel\" title=\"4. What is the formula for finding percentiles in Excel?\">4. What is the formula for finding percentiles in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#5_Can_Excel_calculate_percentiles_starting_from_the_highest_value\" title=\"5. Can Excel calculate percentiles starting from the highest value?\">5. Can Excel calculate percentiles starting from the highest value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#6_Can_I_find_multiple_percentiles_in_Excel\" title=\"6. Can I find multiple percentiles in Excel?\">6. Can I find multiple percentiles in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#7_What_if_I_want_to_find_the_second_highest_percentile\" title=\"7. What if I want to find the second highest percentile?\">7. What if I want to find the second highest percentile?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#8_Can_I_find_the_median_of_a_dataset_starting_from_the_highest_value\" title=\"8. Can I find the median of a dataset starting from the highest value?\">8. Can I find the median of a dataset starting from the highest value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#9_What_if_I_have_missing_values_in_my_dataset\" title=\"9. What if I have missing values in my dataset?\">9. What if I have missing values in my dataset?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#10_Can_I_find_percentiles_for_grouped_data_in_Excel\" title=\"10. Can I find percentiles for grouped data in Excel?\">10. Can I find percentiles for grouped data in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#11_Is_it_possible_to_find_percentiles_for_a_specific_range_within_a_dataset\" title=\"11. Is it possible to find percentiles for a specific range within a dataset?\">11. Is it possible to find percentiles for a specific range within a dataset?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#12_Can_I_find_the_percentile_of_a_value_that_is_not_present_in_the_dataset\" title=\"12. Can I find the percentile of a value that is not present in the dataset?\">12. Can I find the percentile of a value that is not present in the dataset?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_ANSWER_to_the_question_%E2%80%9CHow_to_find_the_percentile_in_Excel_starting_with_the_highest_value%E2%80%9D\"><\/span>The ANSWER to the question &#8220;How to find the percentile in Excel starting with the highest value?&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The answer is to utilize the inverse percentile function in Excel, also known as PERCENTRANK.EXC. It allows you to find the percentile starting from the highest value. By subtracting the result from 1, you will get the desired percentile. Here&#8217;s how you can do it:<\/p>\n<p>1. Organize your data in a column in Excel.<br \/>\n2. In a separate cell, enter the formula `=1-PERCENTRANK.EXC(data_range, value)`, replacing &#8220;data_range&#8221; with the range containing your data and &#8220;value&#8221; with the cell reference of the value for which you want to find the percentile.<br \/>\n3. Press Enter to get the result.<\/p>\n<p>Let&#8217;s illustrate this with an example. Suppose you have a dataset in cells A1 to A10. To find the percentile starting with the highest value for the value in cell B1, you can use the formula `=1-PERCENTRANK.EXC($A$1:$A$10, B1)`. The result will be the desired percentile.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_What_is_a_percentile_in_Excel\"><\/span>1. What is a percentile in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nPercentile is a statistical measure that represents the value below which a specific percentage of data falls. It indicates the relative standing of a particular value within a dataset.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_does_Excel_calculate_percentiles\"><\/span>2. How does Excel calculate percentiles?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nExcel calculates percentiles using the PERCENTILE.EXC function, which estimates the value at a given percentile based on the dataset. By default, it assumes that percentiles are calculated starting with the lowest value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_How_is_PERCENTRANKEXC_different_from_PERCENTILEEXC\"><\/span>3. How is PERCENTRANK.EXC different from PERCENTILE.EXC?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nPERCENTRANK.EXC is used to determine the rank of a value within a dataset, while PERCENTILE.EXC calculates the value at a given percentile.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_is_the_formula_for_finding_percentiles_in_Excel\"><\/span>4. What is the formula for finding percentiles in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe formula for finding percentiles in Excel is `=PERCENTILE.EXC(data_range, percentile)`, where &#8220;data_range&#8221; is the range that contains your data, and &#8220;percentile&#8221; is the desired percentile (expressed as a decimal between 0 and 1).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_Excel_calculate_percentiles_starting_from_the_highest_value\"><\/span>5. Can Excel calculate percentiles starting from the highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, Excel&#8217;s default percentile calculation starts with the lowest value in the dataset. However, we can use the inverse percentile function, PERCENTRANK.EXC, to find percentiles starting from the highest value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_I_find_multiple_percentiles_in_Excel\"><\/span>6. Can I find multiple percentiles in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can find multiple percentiles in Excel by using an array formula. Enter the formula `=PERCENTILE.EXC(data_range, {percentile1, percentile2, &#8230;})`, where you enclose the desired percentiles in curly brackets and press Ctrl + Shift + Enter to obtain the results.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_What_if_I_want_to_find_the_second_highest_percentile\"><\/span>7. What if I want to find the second highest percentile?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo find the second highest percentile in Excel, you can sort your data in descending order and then calculate the percentile using the same formula mentioned earlier.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_find_the_median_of_a_dataset_starting_from_the_highest_value\"><\/span>8. Can I find the median of a dataset starting from the highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can find the median of a dataset starting from the highest value by using the same approach explained above. Simply substitute the desired percentile (0.5 for the median) in the formula.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_What_if_I_have_missing_values_in_my_dataset\"><\/span>9. What if I have missing values in my dataset?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you have missing values in your dataset, Excel will exclude them from the percentile calculation.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_I_find_percentiles_for_grouped_data_in_Excel\"><\/span>10. Can I find percentiles for grouped data in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can calculate percentiles for grouped data in Excel using the FREQUENCY function to create a frequency distribution table, and then applying the same percentile formulas.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Is_it_possible_to_find_percentiles_for_a_specific_range_within_a_dataset\"><\/span>11. Is it possible to find percentiles for a specific range within a dataset?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can find percentiles for a specific range within a dataset by modifying the &#8220;data_range&#8221; in the formula to refer to that range only.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_find_the_percentile_of_a_value_that_is_not_present_in_the_dataset\"><\/span>12. Can I find the percentile of a value that is not present in the dataset?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can find the percentile of a value that is not present in the dataset. The result will indicate the relative position of the non-existent value within the dataset.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset, which helps in understanding the distribution of values. By default, Excel calculates percentiles starting with the lowest value. However, there might be scenarios where you would like to find percentiles &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to find the percentile in Excel starting with the highest value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#more-262318\">Read more<span class=\"screen-reader-text\">How to find the percentile in Excel starting with the highest value?<\/span><\/a><\/p>\n","protected":false},"author":66,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-262318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to find the percentile in Excel starting with the highest value?<\/title>\n<meta name=\"description\" content=\"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to find the percentile in Excel starting with the highest value?\" \/>\n<meta property=\"og:description\" content=\"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-05T11:50:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jamie Steele\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jamie Steele\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\"},\"author\":{\"name\":\"Jamie Steele\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0\"},\"headline\":\"How to find the percentile in Excel starting with the highest value?\",\"datePublished\":\"2024-05-05T11:50:23+00:00\",\"dateModified\":\"2024-05-05T11:50:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\"},\"wordCount\":712,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\",\"name\":\"How to find the percentile in Excel starting with the highest value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-05-05T11:50:23+00:00\",\"dateModified\":\"2024-05-05T11:50:23+00:00\",\"description\":\"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to find the percentile in Excel starting with the highest value?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0\",\"name\":\"Jamie Steele\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Jamie Steele\"},\"description\":\"Guest author Jamie Steele has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to find the percentile in Excel starting with the highest value?","description":"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,","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:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/","og_locale":"en_US","og_type":"article","og_title":"How to find the percentile in Excel starting with the highest value?","og_description":"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,","og_url":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-05-05T11:50:23+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Jamie Steele","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Jamie Steele","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/"},"author":{"name":"Jamie Steele","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0"},"headline":"How to find the percentile in Excel starting with the highest value?","datePublished":"2024-05-05T11:50:23+00:00","dateModified":"2024-05-05T11:50:23+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/"},"wordCount":712,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/","url":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/","name":"How to find the percentile in Excel starting with the highest value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-05-05T11:50:23+00:00","dateModified":"2024-05-05T11:50:23+00:00","description":"Excel is a powerful tool that offers numerous functions to analyze and manipulate data. One common requirement is to find the percentile of a dataset,","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-find-the-percentile-in-excel-starting-with-the-highest-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to find the percentile in Excel starting with the highest value?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0","name":"Jamie Steele","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Jamie Steele"},"description":"Guest author Jamie Steele has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/262318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/66"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=262318"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/262318\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=262318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=262318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=262318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}