{"id":3697,"date":"2016-07-25T08:49:36","date_gmt":"2016-07-25T06:49:36","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=3697"},"modified":"2021-11-05T15:22:34","modified_gmt":"2021-11-05T14:22:34","slug":"hogyan-tudsz-napok-szerint-rendezni","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/","title":{"rendered":"Hogyan tudsz napok szerint rendezni?"},"content":{"rendered":"<p>Az&nbsp;<span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hiba-sorba-rendezesnel-oszlopot-jelolsz-ki\/\" target=\"_blank\" rel=\"noopener\">egyszer\u0171 sorba rendez\u00e9sn\u00e9l<\/a><\/span> m\u00e1r tapasztalhattad, hogy pillanatok alatt \u00e1tvari\u00e1l\u00f3dik az adatok sorrendje. De mi a helyzet, ha napok szerint akarsz rendezni? Hiszen ab\u00e9c\u00e9 sorrendben \u00edgy&nbsp;cs\u00fct\u00f6rt\u00f6k &#8211;&nbsp;h\u00e9tf\u0151&nbsp;&#8211;&nbsp;kedd &#8211; p\u00e9ntek &#8211;&nbsp;szerda lesz az eredm\u00e9ny, nem pedig a <strong>val\u00f3s id\u0151rendi sorrend.<\/strong><!--more--><\/p>\n<h2>Hogyan rendezz&nbsp;napok szerint?<\/h2>\n<p>Ebben az esetben kattints a t\u00e1bl\u00e1zat egy cell\u00e1j\u00e1ra, majd a Rendez\u00e9s \u00e9s sz\u0171r\u00e9s men\u00fcpontn\u00e1l <strong>v\u00e1laszd az Egy\u00e9ni sorrend opci\u00f3t.<\/strong><\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-egyeni-lista.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-3716 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-egyeni-lista.png\" alt=\"AZ egy\u00e9ni sorrend men\u00fcpontban megadhatod, hogy napok szerint rendezzen az Excel.\" width=\"653\" height=\"275\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-egyeni-lista.png 653w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-egyeni-lista-300x126.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-egyeni-lista-240x101.png 240w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/a>A felugr\u00f3 ablakban az Oszlop r\u00e9szen v\u00e1laszd ki a megfelel\u0151 szempontot (Nap), majd a Sorrendn\u00e9l az A-t\u00f3l Z-ig helyett az <strong>Egy\u00e9ni lista opci\u00f3t v\u00e1laszd.<\/strong><\/p>\n<p>Itt meg fogod tal\u00e1lni a H\u00e9tf\u0151, Kedd, Szerda\u2026 naponk\u00e9nti sorrendet.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-napok-szerint.png\"><img decoding=\"async\" class=\"alignleft wp-image-3715 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-napok-szerint.png\" alt=\"Id\u0151rendbe ker\u00fclnek a napok a t\u00e1bl\u00e1zatban.\" width=\"298\" height=\"186\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-napok-szerint.png 298w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/rendezes-napok-szerint-240x150.png 240w\" sizes=\"(max-width: 298px) 100vw, 298px\" \/><\/a>Kattints k\u00e9tszer az OK gombra \u2013 hogy mindk\u00e9t ablakot bez\u00e1rd \u2013, \u00e9s m\u00e1ris \u00e1tker\u00fclnek az adatok napok szerint&nbsp;sorrendbe.<\/p>\n<p><strong>Ugyan\u00edgy m\u0171k\u00f6dik a h\u00f3napok szerinti sorba rendez\u00e9s is.<\/strong><\/p>\n<p>Ha megvan a lista, akkor ugyan\u00fagy <strong>lehet&nbsp;oda \u00e9s vissza is rendezni<\/strong>, mint az \u00e1b\u00e9c\u00e9 sorrendn\u00e9l.<\/p>\n<p>Ebben a feladatban t\u00f6bb \u00e9rdekes funkci\u00f3 mellett 2:36-t\u00f3l a napok szerinti rendez\u00e9st is megmutatom. N\u00e9zd meg a gyakorlatban:<\/p>\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/Fx1PL-Knoq8?start=156\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<h2 class=\"wp-block-heading\">Rendez\u00e9s angol napok szerint<\/h2>\n\n\n\n<p>Az Egy\u00e9ni lista pont alatt&nbsp;Te&nbsp;is <strong>r\u00f6gz\u00edthetsz saj\u00e1t list\u00e1t<\/strong>, ha&nbsp;p\u00e9ld\u00e1ul nem tal\u00e1lod meg&nbsp;az adott nyelv szerinti napok, vagy a h\u00f3napok list\u00e1j\u00e1t, vagy valamilyen egy\u00e9b, fix sorrend szerint akarsz rendezni.<\/p>\n\n\n\n<p>Az egy\u00e9ni lista pontban v\u00e1laszd az &#8216;\u00daj lista&#8217; pontot, \u00e9s a jobb oldali mez\u0151be \u00edrd be soronk\u00e9nt (Enterrel elv\u00e1lasztva) az \u00e1rt\u00e9keket, majd kattints a Hozz\u00e1ad\u00e1s gombra:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" width=\"576\" height=\"386\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/egyeni-lista.png\" alt=\"Angol napok szerint is lehet sorbarendezni az Excelben.\" class=\"wp-image-7681\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/egyeni-lista.png 576w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/egyeni-lista-300x201.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/egyeni-lista-240x161.png 240w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure><\/div>\n\n\n\n<p>Ugyan\u00edgy tudod r\u00f6gz\u00edteni a r\u00f3mai sz\u00e1mokat vagy a ker\u00fcleteket &#8211; ha szeretn\u00e9d egyszer\u0171s\u00edteni a sorbarendez\u00e9st.<\/p>\n\n\n\n<p>Az egy\u00e9ni list\u00e1ba felt\u00f6lt\u00f6tt sorozatokra m\u0171k\u00f6dik az <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/sorozat-felsorolas-kitoltes\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">automatikus kit\u00f6lt\u00e9s<\/span><\/a>, \u00edgy a k\u00e9s\u0151bbi adatbevitelt is meg tudod k\u00f6nny\u00edteni.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mire figyelj az egy\u00e9ni sorrendn\u00e9l?<\/h2>\n\n\n\n<p>Csak akkor tudsz Egy\u00e9ni lista szerint rendezni, ha <strong>karakterre pontosan megegyezik<\/strong> a cell\u00e1ban szerepl\u0151 \u00e9rt\u00e9k a list\u00e1ban szerepl\u0151vel. El\u00e9g egy pont vagy sz\u00f3k\u00f6z k\u00fcl\u00f6nbs\u00e9g, \u00e9s m\u00e1r nem ugyanaz a 2 lista, \u00edgy az eredm\u00e9ny sem az lesz, amit szerett\u00e9l volna.<\/p>\n\n\n\n<p>Ha az Excelben t\u00f6bb \u00e9rt\u00e9k szerepel, mint a megadott list\u00e1ban, akkor el\u0151re veszi a lista (p\u00e9ld\u00e1ul napok szerint) adatait, majd a &#8222;marad\u00e9kot&#8221; a norm\u00e1l sorrend szerint folytatja.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tanulj t\u00f6bb Excel tr\u00fckk\u00f6t<\/h2>\n\n\n\n<p>Tov\u00e1bbi hasznos tippek\u00e9rt &nbsp;\u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg a&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">111 Hasznos Excel Tipp<\/span><\/a> kiadv\u00e1nyt, vagy a Kezd\u0151 &amp; Halad\u00f3 <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Tank\u00f6nyvet<\/a><\/span>!<\/p>\n\n\n\n<p>Ha a munk\u00e1d miatt szeretn\u00e9d \u00e1tfog\u00f3an megismerni, \u00e9s m\u00e9g hat\u00e9konyabban haszn\u00e1lni az Excel t\u00e1bl\u00e1zatokat, akkor gyere hozz\u00e1nk oktat\u00e1sra: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Csoportos <span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Kezd\u0151 tanfolyam<\/strong><\/a><\/span> (Teamsen)<\/li><li>Szem\u00e9lyre szabott, <strong><a rel=\"noreferrer noopener\" href=\"http:\/\/exceltitok.hu\/arak\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">egy\u00e9ni Excel tanfolyam<\/span><\/a><\/strong><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Olvass tov\u00e1bb hasznos Excel tippeket:<\/h3>\n\n\n\n<p><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/ures-sorok-torlese\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/ures-sorok-torlese\/\">Mutatom, hogy t\u00f6r\u00f6ld ki az \u00fcres sorokat a t\u00e1bl\u00e1zatb\u00f3l!<\/a><\/span><br><a href=\"https:\/\/sosexcel.com\/exceltippek\/nyomtatasi-kep-es-oldaltores\/\"><span style=\"text-decoration: underline;\">Nyomtat\u00e1si k\u00e9p \u00e9s oldalt\u00f6r\u00e9s<\/span><\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><img loading=\"lazy\" decoding=\"async\" width=\"728\" height=\"90\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg\" alt=\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t?\" class=\"wp-image-7522\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg 728w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-300x37.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-660x82.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-240x30.jpg 240w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><figcaption><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><span style=\"text-decoration: underline;\">http:\/\/exceltitok.hu\/excel-feladatsorok\/<\/span><\/a><\/figcaption><\/figure><\/div>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/klgPoh8q3CM\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n","protected":false},"excerpt":{"rendered":"<p>Az&nbsp;egyszer\u0171 sorba rendez\u00e9sn\u00e9l m\u00e1r tapasztalhattad, hogy pillanatok alatt \u00e1tvari\u00e1l\u00f3dik az adatok sorrendje. De mi a helyzet, ha napok szerint akarsz rendezni? Hiszen ab\u00e9c\u00e9 sorrendben \u00edgy&nbsp;cs\u00fct\u00f6rt\u00f6k &#8211;&nbsp;h\u00e9tf\u0151&nbsp;&#8211;&nbsp;kedd &#8211; p\u00e9ntek &#8211;&nbsp;szerda lesz az eredm\u00e9ny, nem pedig a val\u00f3s id\u0151rendi sorrend.<\/p>\n","protected":false},"author":1,"featured_media":3720,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[102,1],"tags":[8,75],"class_list":["post-3697","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek","tag-datum","tag-rendezes"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-25T06:49:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-05T14:22:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"266\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan tudsz napok szerint rendezni?\",\"datePublished\":\"2016-07-25T06:49:36+00:00\",\"dateModified\":\"2021-11-05T14:22:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\"},\"wordCount\":565,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\",\"keywords\":[\"d\u00e1tum\",\"rendez\u00e9s\"],\"articleSection\":[\"Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se\",\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\",\"name\":\"Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\",\"datePublished\":\"2016-07-25T06:49:36+00:00\",\"dateModified\":\"2021-11-05T14:22:34+00:00\",\"description\":\"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\",\"width\":850,\"height\":266},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan tudsz napok szerint rendezni?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.","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:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.","og_url":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2016-07-25T06:49:36+00:00","article_modified_time":"2021-11-05T14:22:34+00:00","og_image":[{"width":850,"height":266,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","type":"image\/jpeg"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan tudsz napok szerint rendezni?","datePublished":"2016-07-25T06:49:36+00:00","dateModified":"2021-11-05T14:22:34+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/"},"wordCount":565,"commentCount":4,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","keywords":["d\u00e1tum","rendez\u00e9s"],"articleSection":["Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se","Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/","url":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/","name":"Hogyan tudsz napok szerint rendezni? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","datePublished":"2016-07-25T06:49:36+00:00","dateModified":"2021-11-05T14:22:34+00:00","description":"Az Egy\u00e9ni sorrend men\u00fcben tudod napok szerint vagy h\u00f3napok szerint - azaz val\u00f3s id\u0151rendi sorrendbe - rendezni az adatokat.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","width":850,"height":266},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-tudsz-napok-szerint-rendezni\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan tudsz napok szerint rendezni?"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=3697"}],"version-history":[{"count":17,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3697\/revisions"}],"predecessor-version":[{"id":9294,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3697\/revisions\/9294"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/3720"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=3697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=3697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=3697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}