{"id":5365,"date":"2021-11-29T17:00:00","date_gmt":"2021-11-29T16:00:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5365"},"modified":"2021-12-01T11:39:06","modified_gmt":"2021-12-01T10:39:06","slug":"excel-vegyes-hivatkozas","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/","title":{"rendered":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet?"},"content":{"rendered":"<p><strong>Vegyes hivatkoz\u00e1s sz\u00fcks\u00e9ges, ha 2 ir\u00e1nyban kell m\u00e1solnod<\/strong> (p\u00e9ld\u00e1ul szorz\u00f3t\u00e1bla, l\u00e1sd a cikk v\u00e9g\u00e9n). Am\u00edg csak egy ir\u00e1nyba &#8211; jellemz\u0151en lefel\u00e9 &#8211; m\u00e1solod a k\u00e9pleteket, addig a relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1s ismerete el\u00e9g. <!--more--><\/p>\n<p>A vegyes hivatkoz\u00e1s 2 fajt\u00e1ja<\/p>\n<ul>\n<li>Amikor az oszlop \u00e1lland\u00f3 marad, de a sor v\u00e1ltozik, azaz abszol\u00fat oszlop \u00e9s relat\u00edv sor, p\u00e9ld\u00e1ul $A1, $B2.<\/li>\n<li>Vagy abszol\u00fat, azaz \u00e1lland\u00f3 a sor \u00e9s az oszlop v\u00e1ltozik (vagyis relat\u00edv), p\u00e9ld\u00e1ul A$1, B$2.<\/li>\n<\/ul>\n<p>Vagyis a&nbsp;$ jel az ut\u00e1na k\u00f6vetkez\u0151 r\u00e9szt r\u00f6gz\u00edti. (Azaz $A2-n\u00e9l az A oszlop fix, a sor v\u00e1ltozhat, m\u00edg A$2-n\u00e9l&nbsp;az oszlop v\u00e1ltozhat, \u00e9s a 2. sor a fix.)<\/p>\n<h2>Hov\u00e1 kell abszol\u00fat hivatkoz\u00e1s, azaz $ jel?<\/h2>\n<p>A k\u00e9pletben szerepl\u0151 hivatkoz\u00e1sok mindig arra mozognak, amerre a k\u00e9pletet m\u00e1solod. Bonyolultabb t\u00e1bl\u00e1zatn\u00e1l k\u00fcl\u00f6n-k\u00fcl\u00f6n vizsg\u00e1ld meg a v\u00edzszintes \u00e9s f\u00fcgg\u0151leges mozgat\u00e1st, \u00e9s mindig a megfelel\u0151 helyre tedd be a $-jelet.<\/p>\n<p><strong>Ha a k\u00e9pletet v\u00edzszintesen mozgatod, akkor az oszlopok v\u00e1ltoznak<\/strong>, teh\u00e1t az oszlophivatkoz\u00e1sokr\u00f3l (BET\u0170) kell d\u00f6ntened. Ha sz\u00fcks\u00e9ges, hogy a hivatkoz\u00e1s mindig ugyanaz az oszlop maradjon, akkor r\u00f6gz\u00edtsd.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-jobbra.png\"><img decoding=\"async\" class=\"alignleft wp-image-5368 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-jobbra.png\" alt=\"Vegyes hivatkoz\u00e1s: k\u00e9plet m\u00e1sol\u00e1sa jobbra\" width=\"294\" height=\"74\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-jobbra.png 294w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-jobbra-240x60.png 240w\" sizes=\"(max-width: 294px) 100vw, 294px\" \/><\/a>Pl. az E2 cell\u00e1nak mindig az E oszlopban kell maradnia (\u00e9s nem lehet F2, G2, H2&#8230;). Az E oszlopot r\u00f6gz\u00edtsd \u00e9s \u00edrj $E2-t.<\/p>\n<p><strong>Amikor a k\u00e9pletet f\u00fcgg\u0151legesen mozgatod, akkor a sorok v\u00e1ltoznak, teh\u00e1t a sorhivatkoz\u00e1sokr\u00f3l (SZ\u00c1M) kell d\u00f6ntened.<\/strong><\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-le.png\"><img decoding=\"async\" class=\"alignleft wp-image-5369 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-le.png\" alt=\"Vegyes hivatkoz\u00e1s: k\u00e9plet m\u00e1sol\u00e1sa lefel\u00e9\" width=\"194\" height=\"117\"><\/a><\/p>\n<p>Ha sz\u00fcks\u00e9ges, hogy a hivatkoz\u00e1s mindig ugyanaz a sor maradjon, akkor r\u00f6gz\u00edtsd.<\/p>\n<p>Pl. a B7 cell\u00e1nak mindig a 7. sorban kell maradnia (\u00e9s nem lehet B8, B9, B10&#8230;), akkor a 7. sort r\u00f6gz\u00edtsd \u00e9s \u00edrj B$7-t.<\/p>\n<h2>Mikor melyiket haszn\u00e1ld?<\/h2>\n<p>\u00cdrj egy egyszer\u0171 k\u00e9pletet b\u00e1rmelyik cell\u00e1ba: =A1<br \/>\n(K\u00e9pletekn\u00e9l is <a href=\"https:\/\/sosexcel.com\/exceltippek\/gyorsabb-kepletezes\/\" target=\"_blank\" rel=\"noopener\">haszn\u00e1ld a nyilakat, billenty\u0171zetet!<\/a>)<\/p>\n<p>N\u00e9zz\u00fck mind a 4 esetet!<\/p>\n<p>A \u201cdoll\u00e1rok\u201d k\u00f6z\u00f6tt&nbsp;<strong>legegyszer\u0171bben az F4-gyel tudsz v\u00e1ltani:<\/strong> ahogy nyomod a hivatkoz\u00e1s mellett* az F4-t, \u00fagy &#8216;p\u00f6r\u00f6g&#8217; a relat\u00edv, abszol\u00fat \u00e9s vegyes hivatkoz\u00e1sok k\u00f6z\u00f6tt:&nbsp;=A1 \u21e2&nbsp;=$A$1&nbsp;\u21e2&nbsp;=A$1&nbsp;\u21e2&nbsp;=$A1<\/p>\n<p><em>*&nbsp;Mindig azt a hivatkoz\u00e1st tudod doll\u00e1rozni, amelyikkel&nbsp;\u00e9ppen a kurzor \u00e9rintkezik.<\/em><\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/relativ-hivatkozas.png\"><img decoding=\"async\" class=\"alignleft wp-image-5366 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/relativ-hivatkozas.png\" alt=\"Relat\u00edv marad a hivatkoz\u00e1s, ha t\u00f6bb \u00e9rt\u00e9ket kell \u00e1tsz\u00e1molni, p\u00e9ld\u00e1ul az eladott darabsz\u00e1mokb\u00f3l bev\u00e9telt.\" width=\"215\" height=\"122\"><\/a><strong>A1 (relat\u00edv hivatkoz\u00e1s):<\/strong> Nagyobb ter\u00fcletet elfoglal\u00f3, v\u00e1ltoz\u00f3 adatokkal sz\u00e1molsz. Ha A1 szerepel a k\u00e9pletben, \u00e9s a k\u00e9pletet jobbra m\u00e1solod, akkor m\u00e1r a B1, C1 \u00e9rt\u00e9kkel fog sz\u00e1molni, ha pedig egy sorral lejjebb, akkor az A2, B2, C2 \u00e9rt\u00e9kekkel.<\/p>\n<p><strong>Alap\u00e9rtelmez\u00e9s szerint az Excel relat\u00edv hivatkoz\u00e1sokat haszn\u00e1l.<\/strong> Ha a k\u00e9pletet lem\u00e1solod, akkor az Excel hasonl\u00f3 &#8222;t\u00e1vols\u00e1gokb\u00f3l&#8221; veszi az adatokat.<\/p>\n<p><strong>$A$1 (abszol\u00fat hivatkoz\u00e1s)<\/strong>: Ha egy, fix a cell\u00e1r\u00f3l (f\u00fcggv\u00e9nyben ter\u00fclet is lehet) van sz\u00f3. P\u00e9ld\u00e1ul egy valuta \u00e1rfolyama, egy term\u00e9k \u00e1ra, keres\u00e9si tartom\u00e1ny, stb. B\u00e1rhov\u00e1 m\u00e1solod a k\u00e9pletet, az <strong>mindig az A1 cell\u00e1b\u00f3l<\/strong> veszi majd az \u00e9rt\u00e9ket.<\/p>\n<p>Ha egy cell\u00e1ban &#8211; legyen az az G2 &#8211; \u00e1lland\u00f3 \u00e9rt\u00e9k van (pl. minden s\u00fcti egy\u00e9gesen 350 Ft), akkor a cell\u00e1t (G2) r\u00f6gz\u00edteni kell, amire a $ jelet (\u00e9s az F4 billenty\u0171t) haszn\u00e1ld, \u00edgy $G$2 lesz bel\u0151le. P\u00e9ld\u00e1ul a fenti&nbsp;s\u00fctik bev\u00e9tel\u00e9re a k\u00e9plet: =B2*$G$2<\/p>\n<pre style=\"text-align: center;\">Ha m\u00e9g a relat\u00edv-abszol\u00fat hivatkoz\u00e1s is bizonytalan, itt van 2 egyszer\u0171 feladat, ahol gyakorolhatod:\n<a href=\"https:\/\/sosexcel.com\/exceltippek\/keszits-brutto-netto-berkalkulatort\/\" target=\"_blank\" rel=\"noopener\">K\u00e9sz\u00edts brutt\u00f3-nett\u00f3 b\u00e9rkalkul\u00e1tort Excelben!<\/a>\n<a href=\"https:\/\/exceltitok.hu\/excel-kepletek-irasa-relativ-es-abszolut-hivatkozasok\/\" target=\"_blank\" rel=\"noopener\">Excel k\u00e9pletek \u00edr\u00e1sa \u2013 Relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1sok<\/a><\/pre>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-5367 size-full\" style=\"font-family: inherit; font-style: inherit;\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/07\/vegyes-hivatkozas-.png\" alt=\"A tengelyeken szerepl\u0151 sz\u00e1mok mindig vegyes hivatkoz\u00e1sok lesznak a k\u00e9pletben.\" width=\"216\" height=\"132\"><\/a><\/p>\n<p><strong>A$1 (vegyes hivatkoz\u00e1s)<\/strong>: Sor t\u00edpus\u00fa, fejl\u00e9cszer\u0171 adatokn\u00e1l haszn\u00e1ld.&nbsp;Ha A$1 szerepel a k\u00e9pletben, \u00e9s a k\u00e9pletet jobbra m\u00e1solod, akkor a B1, C1 \u00e9rt\u00e9kkel fog sz\u00e1molni, de ha egy sorral lejjebb, akkor is az A1, B1, C1 \u00e9rt\u00e9kekkel.<\/p>\n<p><strong>$A1 (vegyes hivatkoz\u00e1s):<\/strong> Oszlop t\u00edpus\u00fa, f\u00fcgg\u0151leges elhelyezked\u00e9s\u0171 adatokn\u00e1l alkalmazd.&nbsp;Ha $A1 szerepel a k\u00e9pletben, \u00e9s a k\u00e9pletet jobbra m\u00e1solod, akkor ott is az A1cell\u00e1val fog sz\u00e1molni, ha pedig egy sorral lejjebb, akkor az A2 cell\u00e1ban tal\u00e1lhat\u00f3 \u00e9rt\u00e9kekkel.<\/p>\n<p><strong>Mib\u0151l mi lesz?<\/strong> M\u00e1sold \u00e1t a k\u00e9pletet 2 oszloppal jobbra \u00e9s 2 sorral lejjebb:<\/p>\n<ul>\n<li>Az A1-b\u0151l C3 lesz,<\/li>\n<li>az A$1-b\u0151l C1 lesz,<\/li>\n<li>az $A1-b\u0151l A3 lesz,<\/li>\n<li>az $A$1 marad A1.<\/li>\n<\/ul>\n<h2>Szorz\u00f3t\u00e1bla, a klasszikus p\u00e9lda a vegyes hivatkoz\u00e1sra<\/h2>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-excelben.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-5371 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-excelben.png\" alt=\"Szorz\u00f3t\u00e1bla Excelben: gyakorolhatod a vegyes hivatkoz\u00e1sokat\" width=\"352\" height=\"227\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-excelben.png 352w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-excelben-300x193.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-excelben-240x155.png 240w\" sizes=\"(max-width: 352px) 100vw, 352px\" \/><\/a><\/p>\n<p>K\u00e9sz\u00edts 10 x 10-es szorz\u00f3t\u00e1bl\u00e1t, ahol k\u00f6nnyen ellen\u0151rizheted a tud\u00e1sod.<\/p>\n<p>A&nbsp;<span style=\"font-size: 16px;\">helyes k\u00e9plet&nbsp;=B$1*$A2.<\/span><\/p>\n<p>R\u00e1n\u00e9z\u00e9sre is l\u00e1tsz\u00f3dik, hogy az els\u0151 sorban \u00e9s az A oszlopban vannak az adatok, vagyis ezeket a &#8216;r\u00e9szeket&#8217; kell doll\u00e1rozni a k\u00e9pletben.<\/p>\n<p>Ha bizonytalan vagy a k\u00e9pletedben, akkor gondolkodj<strong>&nbsp;&#8216;\u00e1tl\u00f3san&#8217;, hogy egy kicsit jobbra \u00e9s lejjebb l\u00e9v\u0151 cell\u00e1ban mi lenne a m\u0171k\u00f6d\u0151 k\u00e9plet<\/strong>.<\/p>\n<p>Fontos, hogy ne az azonos sort, oszlopot n\u00e9zd, hiszen ott m\u00e9g sim\u00e1n m\u0171k\u00f6dhet a &#8216;hib\u00e1s&#8217; k\u00e9plet is. (pl. csak a B oszlopra j\u00f3 az =$B$1*A2 k\u00e9plet is.)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-5372 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-4x4.png\" alt=\"Szorz\u00f3t\u00e1bla: m\u0171k\u00f6dik a k\u00e9plet\" width=\"392\" height=\"225\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-4x4.png 392w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-4x4-300x172.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/11\/szorzotabla-4x4-240x138.png 240w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/p>\n<p>P\u00e9ld\u00e1ul m\u00e1sold 3 sorral \u00e9s oszloppal arr\u00e9bb (a 4&#215;4-es cell\u00e1ba) a k\u00e9pletet!<\/p>\n<p>=E$1*$A5-re v\u00e1ltozik, tov\u00e1bbra is a tengelyekr\u0151l v\u00e9ve a megfelel\u0151 sz\u00e1mokat.<\/p>\n<p>(A k\u00e9k hivatkoz\u00e1s az els\u0151 soron megy v\u00e9gig, m\u00edg a piros az A oszlopon bel\u00fcl marad.)<\/p>\n<p>Az <strong>F2 gomb&nbsp;<\/strong>megnyom\u00e1s\u00e1val tudod ellen\u0151rizni a k\u00e9pletedet. Ahogy az el\u0151bb is \u00edrtam, <strong>mindig<\/strong>&nbsp;<strong>n\u00e9zd meg, hogy &#8216;\u00e1tl\u00f3san&#8217; m\u0171k\u00f6dik-e<\/strong>.<\/p>\n<p><strong>A <span style=\"text-decoration: underline;\"><a href=\"https:\/\/excelklub.hu\/\">VIP csoportba<\/a><\/span> felt\u00f6lt\u00f6ttem egy gyakorl\u00f3 feladatsort<\/strong>, amin ellen\u0151rizheted a tud\u00e1sod. Ha m\u00e1r stabilan haszn\u00e1lod az alapokat, \u00e9s szeretn\u00e9l tov\u00e1bb fejl\u0151dni, akkor szeretettel v\u00e1rlak!<\/p>\n<h2>Szeretn\u00e9l t\u00f6bbet tudni az Excelr\u0151l?<\/h2>\n<p>Ha szorgalmas vagy \u00e9s szeretsz k\u00f6nyvb\u0151l tanulni, akkor rendeld meg az&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>.<\/p>\n<p>Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>!<\/p>\n<p>Ha egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vegyes hivatkoz\u00e1s sz\u00fcks\u00e9ges, ha 2 ir\u00e1nyban kell m\u00e1solnod (p\u00e9ld\u00e1ul szorz\u00f3t\u00e1bla, l\u00e1sd a cikk v\u00e9g\u00e9n). Am\u00edg csak egy ir\u00e1nyba &#8211; jellemz\u0151en lefel\u00e9 &#8211; m\u00e1solod a k\u00e9pleteket, addig a relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1s ismerete el\u00e9g.<\/p>\n","protected":false},"author":1,"featured_media":9327,"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":[30,77,76],"class_list":["post-5365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek","tag-adatbazis","tag-hatekonysag","tag-keplet"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\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\/excel-vegyes-hivatkozas\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Vegyes hivatkoz\u00e1s sz\u00fcks\u00e9ges, ha 2 ir\u00e1nyban kell m\u00e1solnod (p\u00e9ld\u00e1ul szorz\u00f3t\u00e1bla, l\u00e1sd a cikk v\u00e9g\u00e9n). Am\u00edg csak egy ir\u00e1nyba &#8211; jellemz\u0151en lefel\u00e9 &#8211; m\u00e1solod a k\u00e9pleteket, addig a relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1s ismerete el\u00e9g.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\" \/>\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=\"2021-11-29T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-01T10:39:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"6 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet?\",\"datePublished\":\"2021-11-29T16:00:00+00:00\",\"dateModified\":\"2021-12-01T10:39:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\"},\"wordCount\":1100,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png\",\"keywords\":[\"adatb\u00e1zis\",\"hat\u00e9konys\u00e1g\",\"k\u00e9plet\"],\"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\/excel-vegyes-hivatkozas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\",\"name\":\"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png\",\"datePublished\":\"2021-11-29T16:00:00+00:00\",\"dateModified\":\"2021-12-01T10:39:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet?\"}]},{\"@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":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","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\/excel-vegyes-hivatkozas\/","og_locale":"hu_HU","og_type":"article","og_title":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Vegyes hivatkoz\u00e1s sz\u00fcks\u00e9ges, ha 2 ir\u00e1nyban kell m\u00e1solnod (p\u00e9ld\u00e1ul szorz\u00f3t\u00e1bla, l\u00e1sd a cikk v\u00e9g\u00e9n). Am\u00edg csak egy ir\u00e1nyba &#8211; jellemz\u0151en lefel\u00e9 &#8211; m\u00e1solod a k\u00e9pleteket, addig a relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1s ismerete el\u00e9g.","og_url":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2021-11-29T16:00:00+00:00","article_modified_time":"2021-12-01T10:39:06+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"6 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet?","datePublished":"2021-11-29T16:00:00+00:00","dateModified":"2021-12-01T10:39:06+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/"},"wordCount":1100,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png","keywords":["adatb\u00e1zis","hat\u00e9konys\u00e1g","k\u00e9plet"],"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\/excel-vegyes-hivatkozas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/","url":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/","name":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png","datePublished":"2021-11-29T16:00:00+00:00","dateModified":"2021-12-01T10:39:06+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/11\/excel_vegyes_hivatkozas_cikk.png","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-vegyes-hivatkozas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Excel vegyes hivatkoz\u00e1s: mikor hov\u00e1 tedd a $ jelet?"}]},{"@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\/5365","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=5365"}],"version-history":[{"count":22,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5365\/revisions"}],"predecessor-version":[{"id":9328,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5365\/revisions\/9328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9327"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}