{"id":1755,"date":"2017-08-11T11:02:09","date_gmt":"2017-08-11T10:02:09","guid":{"rendered":"http:\/\/jakisproblem.pl\/?p=1755"},"modified":"2017-08-11T11:02:09","modified_gmt":"2017-08-11T10:02:09","slug":"excel-dla-zaawansowanych-notatki","status":"publish","type":"post","link":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/2017\/08\/11\/excel-dla-zaawansowanych-notatki\/","title":{"rendered":"Excel dla zaawansowanych &#8211; notatki"},"content":{"rendered":"<h5 id=\"yui_3_17_2_1_1502446332803_41\"><a href=\"https:\/\/e.sggw.pl\/course\/view.php?id=334\">Zaawansowana obs\u0142uga pakietu oprogramowania &#8211; Modu\u0142 2<\/a><\/h5>\n<p>==SUMY.CZ\u0118\u015aCIOWE(A:A) &#8211; zsumowanie tylko danych z filtra;<\/p>\n<p>==SUMA.ILOCZYN\u00d3W(A:A;B:B) &#8211; np. do policzenia sumy dw\u00f3ch kolumn w tablicy &#8211; Cena i Ilo\u015b\u0107;<\/p>\n<p>==POZYCJA(A1;A:A) &#8211; kt\u00f3r\u0105 pozycj\u0119 na li\u015bcie zajmuje dana warto\u015b\u0107;<\/p>\n<p>==WYSZUKAJ.PIONOWO(S1;A:D;C1) &#8211; Znajd\u017a, jak\u0105 warto\u015b\u0107 ma S1 w kolumnie C1 w tabeli A:D;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">Zaawansowana obs\u0142uga pakietu oprogramowania &#8211; Modu\u0142 2 ==SUMY.CZ\u0118\u015aCIOWE(A:A) &#8211; zsumowanie tylko danych z filtra; ==SUMA.ILOCZYN\u00d3W(A:A;B:B) &#8211; np. do policzenia sumy dw\u00f3ch kolumn w tablicy &#8211; Cena i Ilo\u015b\u0107; ==POZYCJA(A1;A:A) &#8211; kt\u00f3r\u0105 pozycj\u0119 na li\u015bcie zajmuje dana warto\u015b\u0107; ==WYSZUKAJ.PIONOWO(S1;A:D;C1) &#8211; Znajd\u017a, jak\u0105 warto\u015b\u0107 ma S1 w kolumnie C1 w tabeli A:D; &nbsp;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/2017\/08\/11\/excel-dla-zaawansowanych-notatki\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[35,9],"class_list":["post-1755","post","type-post","status-publish","format-standard","hentry","category-bez-kategorii","tag-excel","tag-rozne"],"_links":{"self":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/1755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/comments?post=1755"}],"version-history":[{"count":0,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/posts\/1755\/revisions"}],"wp:attachment":[{"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/media?parent=1755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/categories?post=1755"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/u239160.webh.me\/jakisproblem.pl\/index.php\/wp-json\/wp\/v2\/tags?post=1755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}