{"id":202950,"date":"2023-10-25T02:35:13","date_gmt":"2023-10-25T02:35:13","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/"},"modified":"2023-10-25T02:35:13","modified_gmt":"2023-10-25T02:35:13","slug":"how-to-get-the-second-highest-value-in-excel","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/","title":{"rendered":"How to get the second highest value in Excel?"},"content":{"rendered":"<p>Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest value in a range of cells. Whether you&#8217;re working with sales data, test scores, or any other numeric values, Excel makes it easy to locate the second highest value. In this article, we will explore how to accomplish this task using Excel&#8217;s built-in functions.<\/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-get-the-second-highest-value-in-excel\/#How_to_get_the_second_highest_value_in_Excel\" title=\"How to get the second highest value in Excel?\">How to get the second highest value in Excel?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#FAQs_related_to_finding_the_second_highest_value_in_Excel\" title=\"FAQs related to finding the second highest value in Excel:\">FAQs related to finding the second highest value in Excel:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#1_Can_I_use_the_MAX_function_to_find_the_second_highest_value\" title=\"1. Can I use the MAX function to find the second highest value?\">1. Can I use the MAX function to find the second highest value?<\/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-get-the-second-highest-value-in-excel\/#2_What_if_there_are_duplicate_values_in_the_range\" title=\"2. What if there are duplicate values in the range?\">2. What if there are duplicate values in the range?<\/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-get-the-second-highest-value-in-excel\/#3_Can_I_modify_the_formula_to_find_the_third_highest_value\" title=\"3. Can I modify the formula to find the third highest value?\">3. Can I modify the formula to find the third highest value?<\/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-get-the-second-highest-value-in-excel\/#4_What_if_there_are_empty_cells_in_the_range\" title=\"4. What if there are empty cells in the range?\">4. What if there are empty cells in the range?<\/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-get-the-second-highest-value-in-excel\/#5_Can_I_use_the_SMALL_function_to_find_the_second_highest_value\" title=\"5. Can I use the SMALL function to find the second highest value?\">5. Can I use the SMALL function to find the second 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-get-the-second-highest-value-in-excel\/#6_What_happens_if_there_are_text_values_mixed_with_numeric_values_in_the_range\" title=\"6. What happens if there are text values mixed with numeric values in the range?\">6. What happens if there are text values mixed with numeric values in the range?<\/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-get-the-second-highest-value-in-excel\/#7_Can_I_use_conditional_formatting_to_highlight_the_second_highest_value\" title=\"7. Can I use conditional formatting to highlight the second highest value?\">7. Can I use conditional formatting to highlight the second highest value?<\/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-get-the-second-highest-value-in-excel\/#8_How_can_I_handle_ties_for_the_second_highest_value\" title=\"8. How can I handle ties for the second highest value?\">8. How can I handle ties for the second 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-get-the-second-highest-value-in-excel\/#9_Can_I_use_the_RANK_function_to_find_the_second_highest_value\" title=\"9. Can I use the RANK function to find the second highest value?\">9. Can I use the RANK function to find the second highest value?<\/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-get-the-second-highest-value-in-excel\/#10_Is_there_a_shortcut_key_to_find_the_second_highest_value_in_Excel\" title=\"10. Is there a shortcut key to find the second highest value in Excel?\">10. Is there a shortcut key to find the second highest value 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-get-the-second-highest-value-in-excel\/#11_Can_I_drag_and_apply_the_formula_to_multiple_cells_to_find_the_second_highest_value_in_each_row\" title=\"11. Can I drag and apply the formula to multiple cells to find the second highest value in each row?\">11. Can I drag and apply the formula to multiple cells to find the second highest value in each row?<\/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-get-the-second-highest-value-in-excel\/#12_Can_I_use_the_IF_function_to_find_the_second_highest_value\" title=\"12. Can I use the IF function to find the second highest value?\">12. Can I use the IF function to find the second highest value?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_get_the_second_highest_value_in_Excel\"><\/span>How to get the second highest value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To get the second highest value in Excel, you can use a combination of the LARGE and COUNTIFS functions. Here&#8217;s how you can do it:<\/p>\n<p>1. Use the following formula to get the second highest value in a range of cells:<br \/>\n&#8220;`excel<br \/>\n=LARGE(range, COUNTIF(range,&#8221;>&#8221;&#038;LARGE(range,1)))<br \/>\n&#8220;`<br \/>\nIn this formula, &#8220;range&#8221; represents the range of cells that you want to search for the second highest value. The COUNTIF function counts the number of cells that are greater than the largest value in the range. The LARGE function then returns the second largest value in the range.<\/p>\n<p>2. Press Enter to apply the formula, and Excel will display the second highest value in the specified range.<\/p>\n<p>By following these steps, you can quickly and easily find the second highest value in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"FAQs_related_to_finding_the_second_highest_value_in_Excel\"><\/span>FAQs related to finding the second highest value in Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_use_the_MAX_function_to_find_the_second_highest_value\"><\/span>1. Can I use the MAX function to find the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the MAX function only returns the largest value in a range of cells. To find the second highest value, you need to use the LARGE function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_What_if_there_are_duplicate_values_in_the_range\"><\/span>2. What if there are duplicate values in the range?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe formula provided will still work if there are duplicate values in the range. It will return the second highest unique value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Can_I_modify_the_formula_to_find_the_third_highest_value\"><\/span>3. Can I modify the formula to find the third highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can modify the formula by changing the number in the second LARGE function to 3 to find the third highest value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_if_there_are_empty_cells_in_the_range\"><\/span>4. What if there are empty cells in the range?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nEmpty cells will not affect the functionality of the formula. It will only consider the non-empty cells while finding the second highest value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_use_the_SMALL_function_to_find_the_second_highest_value\"><\/span>5. Can I use the SMALL function to find the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the SMALL function returns the nth smallest value, not the nth largest value. You should use the LARGE function to find the second highest value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_What_happens_if_there_are_text_values_mixed_with_numeric_values_in_the_range\"><\/span>6. What happens if there are text values mixed with numeric values in the range?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe formula will return an error if there are text values mixed with numeric values in the range. Make sure the range only contains numeric values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_I_use_conditional_formatting_to_highlight_the_second_highest_value\"><\/span>7. Can I use conditional formatting to highlight the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can apply conditional formatting to highlight the cell that contains the second highest value. Use a formula-based rule with the formula provided earlier.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_can_I_handle_ties_for_the_second_highest_value\"><\/span>8. How can I handle ties for the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf there are ties for the highest value in the range, the formula will return the second unique highest value. If you want to include ties, you will need a more complex formula.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_use_the_RANK_function_to_find_the_second_highest_value\"><\/span>9. Can I use the RANK function to find the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhile the RANK function can be used, it may be more complicated than using the LARGE function. The formula provided earlier is a simpler solution.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Is_there_a_shortcut_key_to_find_the_second_highest_value_in_Excel\"><\/span>10. Is there a shortcut key to find the second highest value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThere is no specific shortcut key for finding the second highest value. You will need to enter the formula manually to achieve this.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Can_I_drag_and_apply_the_formula_to_multiple_cells_to_find_the_second_highest_value_in_each_row\"><\/span>11. Can I drag and apply the formula to multiple cells to find the second highest value in each row?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can drag the formula across multiple cells to find the second highest value in each row or column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_I_use_the_IF_function_to_find_the_second_highest_value\"><\/span>12. Can I use the IF function to find the second highest value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nWhile the IF function can be used to customize the result based on certain conditions, it is not necessary for finding the second highest value. The formula with the LARGE and COUNTIF functions is sufficient for this task.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest value in a range of cells. Whether you&#8217;re working with sales data, test scores, or any other numeric values, Excel makes it easy to locate the second highest value. In &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get the second highest value in Excel?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#more-202950\">Read more<span class=\"screen-reader-text\">How to get the second highest value in Excel?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-202950","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 get the second highest value in Excel?<\/title>\n<meta name=\"description\" content=\"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest\" \/>\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-get-the-second-highest-value-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get the second highest value in Excel?\" \/>\n<meta property=\"og:description\" content=\"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\" \/>\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=\"2023-10-25T02:35:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\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=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-get-the-second-highest-value-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to get the second highest value in Excel?\",\"datePublished\":\"2023-10-25T02:35:13+00:00\",\"dateModified\":\"2023-10-25T02:35:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\"},\"wordCount\":681,\"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-get-the-second-highest-value-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\",\"name\":\"How to get the second highest value in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-10-25T02:35:13+00:00\",\"dateModified\":\"2023-10-25T02:35:13+00:00\",\"description\":\"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get the second highest value in Excel?\"}]},{\"@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\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"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\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes 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 get the second highest value in Excel?","description":"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest","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-get-the-second-highest-value-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to get the second highest value in Excel?","og_description":"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-10-25T02:35:13+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to get the second highest value in Excel?","datePublished":"2023-10-25T02:35:13+00:00","dateModified":"2023-10-25T02:35:13+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/"},"wordCount":681,"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-get-the-second-highest-value-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/","name":"How to get the second highest value in Excel?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-10-25T02:35:13+00:00","dateModified":"2023-10-25T02:35:13+00:00","description":"Excel is a powerful tool for data analysis, but sometimes finding specific information can be a challenge. One common task is finding the second highest","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-the-second-highest-value-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get the second highest value in Excel?"}]},{"@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\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","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":"Adam Forbes"},"description":"Guest author Adam Forbes 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\/202950","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\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=202950"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/202950\/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=202950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=202950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=202950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}