{"id":89632,"date":"2021-06-28T14:17:52","date_gmt":"2021-06-28T12:17:52","guid":{"rendered":"https:\/\/learnesy.com\/?p=89632"},"modified":"2022-03-02T12:39:35","modified_gmt":"2022-03-02T10:39:35","slug":"video-slumpmatris","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/video-slumpmatris\/","title":{"rendered":"Video: Slumpmatris"},"content":{"rendered":"\r\n<p>Sista veckan innan sommaruppeh\u00e5llet med Excels dynamiska matrisfunktioner. <br \/><br \/>Skapa ett helt slumpat cellomr\u00e5de baserat p\u00e5 en lista v\u00e4rden med SLUMPMATRIS!<br \/><br \/>I st\u00e4llet f\u00f6r att anv\u00e4nda separata funktioner f\u00f6r att skapa ett omr\u00e5de med slumpm\u00e4ssiga v\u00e4rden, kan du generera flera slumpade kolumner och rader med en och samma funktion.<br \/>Kontrollera antalet rader och kolumner som ska fyllas med v\u00e4rden, samt maximum- och miniminummer.<br \/>Koppla dessa slumpade nummer till andra v\u00e4rden, som till exempel namn, med hj\u00e4lp av en INDEX funktion!<br \/><br \/>(Funktionen heter TILFELDIGMATRISE p\u00e5 norsk \ud83c\uddf3\ud83c\uddf4)\u00a0<\/p>\r\n<p><div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/561443803?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div><\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Sista veckan innan sommaruppeh\u00e5llet med Excels dynamiska matrisfunktioner. Skapa ett helt slumpat cellomr\u00e5de baserat p\u00e5 en lista v\u00e4rden med SLUMPMATRIS! I st\u00e4llet f\u00f6r att anv\u00e4nda separata funktioner f\u00f6r att skapa ett omr\u00e5de med slumpm\u00e4ssiga v\u00e4rden, [&hellip;]<\/p>\n","protected":false},"author":26679,"featured_media":89633,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[218,247,65,188],"class_list":["post-89632","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-excel-online","tag-excelfunktioner","tag-excelkurs","tag-slumpmatris"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/89632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/26679"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=89632"}],"version-history":[{"count":4,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/89632\/revisions"}],"predecessor-version":[{"id":135839,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/89632\/revisions\/135839"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/89633"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=89632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=89632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=89632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}