{"id":125501,"date":"2021-12-10T14:47:14","date_gmt":"2021-12-10T12:47:14","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/storsta-minsta\/"},"modified":"2023-05-12T16:01:10","modified_gmt":"2023-05-12T15:01:10","slug":"storsta-minsta","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/storsta-minsta\/","title":{"rendered":"ST\u00d6RSTA, MINSTA"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/rang\/\">RANG<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/median-typvarde\/\">MEDIAN &amp; TYPV\u00c4RDE<\/a> |<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185011955?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys f\u00f6rdjupningskurs i Excel, <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>ST\u00d6RSTA-funktionen i Excel returnerar ett numeriskt v\u00e4rde baserat p\u00e5 dess position i en matris, d\u00e5 den sorteras efter v\u00e4rde i fallande ordning. Funktionen ST\u00d6RSTA returnerar det <em>n:te st\u00f6rsta v\u00e4rdet<\/em> \u2013 1:a st\u00f6rsta v\u00e4rdet, 2:a st\u00f6rsta v\u00e4rdet, 3:e st\u00f6rsta v\u00e4rdet, osv.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syfte<\/strong><br>Erh\u00e5lla det n:te st\u00f6rsta v\u00e4rdet<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Returv\u00e4rde<\/strong><br>Det n:te st\u00f6rsta v\u00e4rdet i en matris<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Argument<\/strong><br><em>matris<\/em> \u2013 en matris eller ett omr\u00e5de med numeriska v\u00e4rden<br><em>n<\/em> \u2013 position, d\u00e4r 1 motsvarar det st\u00f6rsta v\u00e4rdet, 2 motsvarar det n\u00e4st st\u00f6rsta, osv.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syntax<\/strong><br>=ST\u00d6RSTA(matris, n)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>MINSTA-funktionen i Excel returnerar ett numeriskt v\u00e4rde baserat p\u00e5 dess position i en matris, d\u00e5 den sorteras efter v\u00e4rde i stigande ordning. Funktionen MINSTA returnerar det <em>n:te minsta v\u00e4rdet<\/em> \u2013 1:a minsta v\u00e4rdet, 2:a minsta v\u00e4rdet, 3:e minsta v\u00e4rdet, osv.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syfte<\/strong><br>Erh\u00e5lla det n:te minsta v\u00e4rdet<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Returv\u00e4rde<\/strong><br>Det n:te minsta v\u00e4rdet i en matris<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Argument<\/strong><br><em>matris<\/em> \u2013 en matris eller ett omr\u00e5de med numeriska v\u00e4rden<br><em>n<\/em> \u2013 position, d\u00e4r 1 motsvarar det minsta v\u00e4rdet, 2 motsvarar det n\u00e4st minsta, osv.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syntax<\/strong><br>=MINSTA(matris, n)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Hur anv\u00e4nder man funktionerna ST\u00d6RSTA och MINSTA i Excel? <\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 grundl\u00e4ggande exempel<\/h3>\n\n\n\n<p>Nedan returnerar funktionen ST\u00d6RSTA <em>det fj\u00e4rde st\u00f6rsta v\u00e4rdet<\/em> i en lista med sju tal som tillhandah\u00e5lls i en matriskonstant*.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=ST\u00d6RSTA({3;100;76;-3;89;4321;98};4)<\/pre>\n\n\n\n<p>Funktionen ST\u00d6RSTA returnerar i det h\u00e4r fallet talet 89. <\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><em>*v\u00e4rden omslutna av klammerparenteser som i exemplet ovan<\/em><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 2 \u2013 det minsta och st\u00f6rsta v\u00e4rdet fr\u00e5n ett namngivet intervall<\/h3>\n\n\n\n<p>Nedan returnerar funktionerna ST\u00d6RSTA respektive MINSTA, det st\u00f6rsta respektive minsta v\u00e4rdet fr\u00e5n ett definierat omr\u00e5de.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=ST\u00d6RSTA(data;1)<br>=MINSTA(data;1)<\/pre>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 3 \u2013 MINSTA f\u00f6r att visa st\u00f6rsta v\u00e4rdet<\/h3>\n\n\n\n<p>F\u00f6r att visa hur n\u00e4ra besl\u00e4ktade de b\u00e5da funktionerna \u00e4r, kan vi &#8221;invertera&#8221; de b\u00e5da funktionerna och s\u00e5ledes erh\u00e5lla <em>det minsta v\u00e4rdet<\/em> med ST\u00d6RSTA-funktionen och vice versa. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"738\" height=\"738\" src=\"\/wp-content\/uploads\/2022\/12\/excel-funktion-storsta-minsta.jpg\" alt=\"\" class=\"wp-image-196991\" srcset=\"\/wp-content\/uploads\/2022\/12\/excel-funktion-storsta-minsta.jpg 738w, \/wp-content\/uploads\/2022\/12\/excel-funktion-storsta-minsta-300x300.jpg 300w, \/wp-content\/uploads\/2022\/12\/excel-funktion-storsta-minsta-150x150.jpg 150w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 3: Bilden illustrerar hur man kan anv\u00e4nda funktionen MINSTA f\u00f6r att visa det st\u00f6rsta v\u00e4rdet. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">=MINSTA(B3:B26;RADER(B3:B26))\n=ST\u00d6RSTA(B3:B26;RADER(B3:B26))<\/pre>\n\n\n\n<p>H\u00e4r kombineras funktionerna ST\u00d6RSTA och MINSTA med funktionen <em>RADER<\/em>. Funktionen RADER returnerar antalet rader i en referens eller matris. Funktionen returnerar allts\u00e5 <em>l\u00e4ngden<\/em> av matrisen ovan. Det betyder att funktionen returnerar det <em>sista v\u00e4rdet <\/em>f\u00f6r det andra argumentet, n. P\u00e5 s\u00e5 vis erh\u00e5lls det minst minsta v\u00e4rdet och det minst st\u00f6rsta v\u00e4rdet.  <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionerna ST\u00d6RSTA och MINSTA<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Funktionen ST\u00d6RSTA<\/h3>\n\n\n\n<p>Funktionen ST\u00d6RSTA returnerar ett numeriskt v\u00e4rde baserat p\u00e5 dess position i en matris n\u00e4r den sorteras efter v\u00e4rde. Funktionen ST\u00d6RSTA returnerar det n:te st\u00f6rsta v\u00e4rdet i en matris, d\u00e4r 1 motsvarar det st\u00f6rsta v\u00e4rdet, 2 motsvarar det n\u00e4st st\u00f6rsta v\u00e4rdet, osv.<br>Funktionen ST\u00d6RSTA tar tv\u00e5 argument, <em>matris<\/em> och <em>n<\/em> med syntax <em>=ST\u00d6RSTA(matris;n)<\/em>. <br>Argumentet <em>matris<\/em> \u00e4r en matris eller ett omr\u00e5de med numeriska v\u00e4rden. Argumentet <em>n<\/em> representerar position eller rang.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Funktionen MINSTA<\/h3>\n\n\n\n<p>Funktionen MINSTA returnerar ett numeriskt v\u00e4rde baserat p\u00e5 dess position i en matris n\u00e4r den sorteras efter v\u00e4rde. Funktionen MINSTA returnerar det n:te minsta v\u00e4rdet i en matris, d\u00e4r 1 motsvarar det minsta v\u00e4rdet, 2 motsvarar det n\u00e4st minsta v\u00e4rdet, osv.<br>Funktionen MINSTA tar tv\u00e5 argument, <em>matris<\/em> och <em>n<\/em> med syntax <em>=MINSTA(matris;n)<\/em>. <br>Argumentet <em>matris<\/em> \u00e4r en matris eller ett omr\u00e5de med numeriska v\u00e4rden. Argumentet <em>n<\/em> representerar position eller rang.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ST\u00d6RSTA och MINSTA ignorerar tomma celler, textv\u00e4rden och v\u00e4rden som kodas som <em>SANT<\/em> eller <em>FALSKT<\/em>.<\/li>\n\n\n\n<li>Om matrisen inte inneh\u00e5ller n\u00e5gra numeriska v\u00e4rden returnerar ST\u00d6RSTA och MINSTA felet <em>#OGILTIGT!<\/em>.<\/li>\n\n\n\n<li>F\u00f6r att best\u00e4mma rangen f\u00f6r ett tal i en datam\u00e4ngd, anv\u00e4nd <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/rang\/\"><em>RANK-funktionen<\/em><\/a>.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om funktionerna ST\u00d6RSTA och MINSTA i v\u00e5r kurs <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>F\u00f6r det mest f\u00f6rekomna v\u00e4rdet, anv\u00e4nd funktionen <em><a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/median-typvarde\/\">TYPV\u00c4RDE<\/a><\/em>.<\/li>\n\n\n\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionerna? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a> eller v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys <a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a> hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[308],"class_list":["post-125501","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-statistiska-funktioner-sv"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/125501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=125501"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}