Contents
I ka nānā mua ʻana (i ka heluhelu ʻana i ke kōkua), ka hana AOLE (KANAKA) nānā maʻalahi a pono ʻole. ʻO kona kumu, ʻo ia ka hoʻohuli ʻana i ka kikokikona e like me ka loulou i kahi loulou piha. ʻO kēlā mau mea. inā pono mākou e kuhikuhi i ka cell A1, a laila hiki iā mākou ke hana i kahi loulou pololei (e hoʻokomo i kahi hōʻailona like ma D1, kaomi ma A1 a kaomi iā Enter), a i ʻole hiki iā mākou ke hoʻohana. AOLE no ka mea hookahi:
E ʻoluʻolu, e hoʻokomo ʻia ka hoʻopaʻapaʻa hana - kahi kuhikuhi i ka A1 - i nā kaha puanaʻi, no laila, ʻoiaʻiʻo, he kikokikona ma aneʻi.
"ʻAe, maikaʻi," ʻōlelo ʻoe. “A he aha ka pōmaikaʻi?”
Akā, mai hoʻokolokolo ma ka manaʻo mua - he hoʻopunipuni. Hiki i kēia hiʻohiʻona ke kōkua iā ʻoe i nā kūlana he nui.
Laʻana 1. Transpose
ʻO kahi maʻamau o ke ʻano: pono ʻoe e hoʻohuli i ka dia vertical
ʻāwīwī i ka pae (transpose). ʻOiaʻiʻo, hiki iā ʻoe ke hoʻohana i kahi hoʻokomo kūikawā a i ʻole hana HANAU (HULEHU) i loko o kahi papa kuhikuhi, akā hiki iā ʻoe ke loaʻa me kā mākou AOLE:
He maʻalahi ka loiloi: no ka loaʻa ʻana o ka helu o ke kelepona aʻe, hoʻopili mākou i ka leka "A" me ke ʻano kūikawā "&" a me ka helu kolamu o ka cell o kēia manawa, ka mea i hāʻawi ʻia e ka hana iā mākou. kolamu (KOLOHE).
ʻOi aku ka maikaʻi o ke kaʻina hana hoʻohuli. Mai kēia manawa pono mākou e hana i kahi loulou i nā cell B2, C2, D2, a me nā mea ʻē aʻe, ʻoi aku ka maʻalahi o ka hoʻohana ʻana i ka mode link R1C1 ma kahi o ka "kaua moana". Ma kēia ʻano, ʻokoʻa kā mākou mau cell i ka helu kolamu: B2=R1C2, C2=R1C3, D2=R1C4 etc.
ʻO kēia kahi e komo ai ka manaʻo hana koho lua. AOLE. Ina ua like HEWAE (FALSE), a laila hiki iā ʻoe ke hoʻonohonoho i ka leka uila ma ke ʻano R1C1. No laila hiki iā mākou ke hoʻololi maʻalahi i ka pae ākea i ka vertical:
Laʻana 2. E hōʻuluʻulu i ka wā
Ua ʻimi mua mākou i kahi ala o ka hōʻuluʻulu ʻana ma luna o ka puka makani (nui) o ka nui i hāʻawi ʻia ma kahi pepa me ka hoʻohana ʻana i ka hana HOOPAU (OFFSET). Hiki ke hoʻoponopono ʻia kahi pilikia like me ka hoʻohana ʻana AOLE. Inā pono mākou e hōʻuluʻulu i ka ʻikepili wale nō mai kahi manawa ākea, a laila hiki iā mākou ke kāpili iā ia mai nā ʻāpana a laila hoʻohuli iā ia i kahi loulou piha, hiki iā mākou ke hoʻokomo i loko o ka hana. ʻO SUM (SUM):
Laʻana 3. Papa kuhikuhi papa kuhikuhi papa kuhikuhi
I kekahi manawa ʻaʻole mālama ʻo Microsoft Excel i nā inoa papaʻaina akamai a me nā kolamu ma ke ʻano he loulou piha. No laila, no ka laʻana, ke hoʻāʻo nei e hana i kahi papa inoa hāʻule i lalo (tab ʻIkepili - Hōʻoiaʻikepili) ma muli o ke kolamu limahana mai ka papaʻaina akamai People e loaʻa iā mākou kahi hewa:
Inā mākou e "uhi" i ka loulou me kā mākou hana AOLE, a laila e ʻae maʻalahi ʻo Excel a e hōʻano hou ʻia kā mākou papa inoa hāʻule i lalo i ka wā e hoʻohui ai i nā limahana hou i ka hopena o ka papa akamai:
Laʻana 4. Unbreakable Links
E like me kāu e ʻike ai, hoʻoponopono ʻokoʻa ʻo Excel i nā ʻōlelo kuhikuhi i loko o nā formulas i ka wā e hoʻokomo ai a holoi paha i nā kolamu lālani ma kahi pepa. I ka hapanui o nā hihia, pololei a maʻalahi kēia, akā ʻaʻole mau. E ʻōlelo mākou pono mākou e hoʻololi i nā inoa mai ka papa kuhikuhi limahana i ka hōʻike:
Inā hoʻokomo ʻoe i nā loulou maʻamau (e hoʻokomo i ka =B2 i loko o ke kelepona ʻōmaʻomaʻo mua a kope iā ia i lalo), a laila ke holoi ʻoe, no ka laʻana, Dasha, e loaʻa iā mākou ka #LINK! hewa i loko o ke kelepona ʻōmaʻomaʻo e pili ana iā ia. (#REF!). I ka hihia o ka hoʻohana ʻana i ka hana e hana i nā loulou AOLE aole pilikia pela.
Laʻana 5: ʻOhi ʻikepili mai nā pepa lehulehu
Inā paha he 5 mau pepa me nā hōʻike like ʻole mai nā limahana like ʻole (Mikhail, Elena, Ivan, Sergey, Dmitry):
E noʻonoʻo kākou ua like ke ʻano, ka nui, ke kūlana a me ke kaʻina o nā waiwai a me nā mahina ma nā papa a pau - ʻokoʻa nā helu.
Hiki iā ʻoe ke hōʻiliʻili i ka ʻikepili mai nā pepa a pau (mai hōʻuluʻulu ʻia, akā e kau ma lalo o kekahi i kekahi i loko o kahi "puʻu") me hoʻokahi wale nō kumu:
E like me kāu e ʻike ai, ua like ka manaʻo: hoʻopili mākou i ka loulou i ka cell i makemake ʻia o ka pepa i hāʻawi ʻia, a AOLE huli ia i "ola". No ka maʻalahi, ma luna o ka papaʻaina, ua hoʻohui au i nā leka o nā kolamu (B,C,D), a ma ka ʻākau - nā helu laina e pono e lawe ʻia mai kēlā me kēia pepa.
Pitfalls
Ināʻoe e hoʻohana ana AOLE (KANAKA) pono ʻoe e hoʻomanaʻo e pili ana i kona mau nāwaliwali:
- Inā hoʻopili ʻoe i kahi faila ʻē aʻe (ma ka hoʻopili ʻana i ka inoa faila ma nā bracket square, ka inoa pepa, a me ka helu kelepona), a laila e hana wale ʻia ke wehe ʻia ka faila kumu. Inā pani mākou, loaʻa ka hewa #LINK!
- ʻAʻole hiki ke kuhikuhi ʻia ʻo INDIRECT i kahi laulā i kapa ʻia. Ma ka static - ʻaʻohe pilikia.
- ʻO INDIRECT kahi hana maʻalahi a i ʻole "volatile", ʻo ia hoʻi, helu hou ʻia no ka hoʻololi ʻana i kekahi cell o ka lau, ʻaʻole hoʻohuli wale i nā cell, e like me nā hana maʻamau. He hopena maikaʻi ʻole kēia i ka hana a ʻoi aku ka maikaʻi o ka lawe ʻole ʻia me nā papa INDIRECT nui.
- Pehea e hana ai i kahi laulima ikaika me ka hoʻonui ʻana
- Ka hōʻuluʻulu ʻana ma luna o kahi puka aniani ma kahi pepa me ka hana OFFSET