{"id":3160,"date":"2023-11-12T14:42:32","date_gmt":"2023-11-12T14:42:32","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/"},"modified":"2023-12-03T11:20:09","modified_gmt":"2023-12-03T11:20:09","slug":"kleinster-wert-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/","title":{"rendered":"Wie finde ich den kleinsten wert in einer spalte?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-1248033301\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Um die kleinste Zahl in Excel zu finden, k\u00f6nnen Sie die Funktion SMALL von Excel verwenden. Mit dieser Funktion k\u00f6nnen Sie auf einen Bereich verweisen, in dem Sie Zahlen haben, und den Wert n angeben (wenn Sie beispielsweise die kleinste Zahl erhalten m\u00f6chten, geben Sie 1 ein).<\/p><p> In diesem Tutorial erfahren Sie, wie Sie eine schnelle Formel schreiben, um die kleinste Zahl zu erhalten.<\/p><h2 class=\"wp-block-heading\"> Formel zum Finden der kleinsten Zahl in Excel<\/h2><p> Sie k\u00f6nnen die folgenden Schritte verwenden:<\/p><ol type=\"1\"><li> Geben Sie zun\u00e4chst die Funktion SMALL in eine Zelle ein.<\/li><li> Beziehen Sie sich danach auf den Bereich, in dem Sie Zahlen haben.<\/li><li> Geben Sie dann die n Werte ein, um die n-te Zahl zu finden.<\/li><li> Dr\u00fccken Sie am Ende die Eingabetaste, um das Ergebnis zu erhalten. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79466\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"Finden Sie den kleinsten Wert\" width=\"371\" height=\"91\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SMALL(A2:A12,1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79467\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-pour-trouver-le-plus-petit-nombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"Formel, um die kleinste Zahl zu finden\" width=\"363\" height=\"559\"><\/figure><\/div><p> In Ihrer Liste ist 104 die kleinste Zahl und genau das haben Sie im Ergebnis. Und wenn Sie irgendwie die <sup>drittkleinste<\/sup> Zahl erhalten m\u00f6chten, k\u00f6nnen Sie die 3 im k-Argument der Funktion verwenden. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Holen Sie sich die Excel-Datei<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/plus-petite-valeur.xlsx\" rel=\"nofollow\">Herunterladen<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/formeln\/\">Liste der Excel-Formeln<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Verwandte Formeln <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/variationskoeffizient\/\">Berechnen Sie den Variationskoeffizienten (CV) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/maximal-wenn\/\">MAX IF in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/bericht\/\">Berechnen Sie schnell das Verh\u00e4ltnis in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/niedrigster-wert\/\">Finden Sie den niedrigsten Wert aus einer Liste von Zahlen (N).<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/die-haufigsten-zahlen\/\">Ermitteln Sie die h\u00e4ufigste(n) Zahl(en) eines Arrays<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3160","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:20:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/\",\"name\":\"\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png\",\"datePublished\":\"2023-11-12T14:42:32+00:00\",\"dateModified\":\"2023-12-03T11:20:09+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie finde ich den kleinsten wert in einer spalte?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?","description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.","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:\/\/exceladvisor.org\/de\/kleinster-wert-2\/","og_locale":"de_DE","og_type":"article","og_title":"\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?","og_description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.","og_url":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:20:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/","url":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/","name":"\u25b7 Wie finde ich den kleinsten Wert in einer Spalte?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png","datePublished":"2023-11-12T14:42:32+00:00","dateModified":"2023-12-03T11:20:09+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie Excel-Formeln mit SMALL-Funktionen schreiben, um den kleinsten Wert in einem Bereich zu erhalten.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trouver-la-plus-petite-valeur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/kleinster-wert-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie finde ich den kleinsten wert in einer spalte?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3160"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3160\/revisions"}],"predecessor-version":[{"id":3989,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3160\/revisions\/3989"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}