ʻO ka hoʻoponopono ʻana a me ka holoi ʻana i ka ʻikepili ma Excel he ʻano hana hiki ʻole. Inā he liʻiliʻi ka ʻikepili, a laila ʻaʻohe pilikia me ka hoʻoponopono a holoi ʻana paha. Inā pono ʻoe e hoʻololi i ka nui o nā hoʻololi, a laila ʻoi aku ka nui o ka hoʻoikaika ʻana. A hiki loa i ka hana ʻana pēlā e hana hewa ai ʻoe.
ʻO ke kaʻina hana o ka wehe ʻana i nā kope ma Excel hiki ke hana maʻalahi, akā hoʻopau manawa. ʻO ka mea pōmaikaʻi, ua maʻalahi kēia mea hana a me ka maikaʻi, no laila hiki iā ia ke kōkua maoli iā ʻoe e hoʻokele i nā laina he nui i ka hele hoʻokahi.
Hāʻawi ʻo Excel i ʻekolu mau mea hana no ka hana ʻana i nā kope. Hoʻopau kekahi iā lākou, ʻike ka lua iā lākou, a ʻae ke kolu iā ʻoe e kānana. I kēia lā, e hōʻike wau iā ʻoe pehea e hana ai ka mea hana hoʻohemo ʻelua ʻoiai ʻo kēia hana kekahi o nā hana kaulana loa ma Excel.
Pono: Pono e hoʻonohonoho i ka ʻikepili ma Excel
Ma ka laʻana kīhini ma lalo nei, e ʻike ʻoe pehea e wehe ai i nā laina pālua me ka hoʻoikaika liʻiliʻi. E nānā i kaʻu ʻikepili:
Hoʻonohonoho ʻia nā papa ʻaina a pau i nā kolamu ma ka lā a me ka ʻāina i hana ʻia. ʻO ka hopena, ua hoʻopau wau me 3 mau kope: papa (palapala), ʻōlapa (mau ipu) a kīʻaha kō (nā kīʻaha kō) ʻaʻole wau makemake e ʻike ʻelua i ka papaʻaina.
No ka hoʻonohonoho ʻana i ka laulā kūpono, kaomi ʻākau ma kekahi kelepona me ka ʻikepili, e hele i ka pā hookomo (Hoʻokomo) a koho papaʻaina (Pakaukau). He mea nui e nānā i ka laulā ʻikepili i koho ʻia i kēia manawa. Inā pololei nā mea a pau, kaomi OK.
E huli a wehe i nā mea hoʻokomo kope
No ka wehe ʻana i nā kope kope, kaomi au ma kekahi kelepona i ka papaʻaina, e hele i ka pā 'Ikepili (Data) a koho i ka mea hana Wehe i nā Duplicate (Wehe i nā kope). Wehe ʻia ka pahu kamaʻilio o ka inoa like:
Hiki i kēia pukaaniani ke koho i kekahi helu o nā kolamu e nānā ʻia. Koho au i nā mea ʻekolu a pau no ka mea aia i loko o lākou nā helu kope e pono iaʻu e wehe. A laila kaomi wale wau OK.
Hōʻike ka pahu kamaʻilio ma hope o ka pau ʻana o ka hoʻoili ʻikepili i ka nui o nā kope i loaʻa a wehe ʻia ʻo Excel. Kaomi OK:
ʻO ka hopena, ʻaʻohe kope i ka papaʻaina, wikiwiki a maʻalahi nā mea a pau. ʻO ka mea hana hoʻoneʻe pālua i kūkulu ʻia ma Excel e mālama pono iā ʻoe i ka manawa, ʻoiai inā ʻoe e hana ana me nā papa i loaʻa nā tausani o nā lālani me nā ʻano ʻikepili like ʻole. E ho'āʻo iā ʻoe iho a ʻike ʻoe i ka wikiwiki e hiki ai iā ʻoe ke hoʻokō i ka hopena i makemake ʻia.