Te kowhiri i tetahi whakaahua mai i te rarangi takaiho

Te whakatakoto i te raruraru

Me mohio kei roto i tetahi o nga ruma o te pepa he rarangi taka-iho me nga ingoa, ka tohua mai i tera, ka whakaatuhia te hua ki tona taha hei whakaahua:

Ataata

Hipanga 1. Waihangahia he whaiaronga me tetahi whakaahua ka hoatu he ingoa

Ka hanga tatou i runga Rarangi 1 he pukapuka matou me nga ingoa me nga whakaahua o nga taonga, e rua nga pou (tauira и whakaahua):

Inaianei me hoatu he ingoa ki ta maatau raarangi korero hei tohu atu mo nga ra kei mua. I roto i te Excel 2003 me te pakeke ake, mo tenei ka haere tatou ki te tahua Kōkuhu – Ingoa – Tautapa (Kōkuhu – Ingoa – Tautuhia), i roto i te Excel 2007 me te mea hou ake - pawhiria te paatene Kaiwhakahaere Ingoa ripa Ngā tauira. Waihangahia he awhe – whakauruhia he ingoa (hei tauira Pukaemi Whakaahua) ka whakapūtātia te tātai hei wāhitau:

=СМЕЩ(Лист1!$A$1;1;0;СЧЁТЗ(Лист1!$A:$A)-1;1)

=OFFSET(Лист1!$A$1;1;0;COUNTA(Лист1!$A:$A)-1;1)

Ka whakatauhia e tenei tauira te pūtau whakamutunga e nohoia ana i te tīwae A me te whakaputa i te awhe mai i A2 ki tenei pūtau kua kitea. Ko te hanga tino uaua e hiahiatia ana hei taapiri i nga tauira hou ki ta maatau rarangi ingoa me te kore e whakaaro ki te whakatika i te awhe. Mena karekau koe e hiahia ki te taapiri i tetahi mea, kaua e uru ki tenei tauira whakamataku, uru noa =A2:A5

Hipanga 2. Rarangi taka-iho mo te whiriwhiri tauira

Haere tatou ki Reta 2 ka hanga i tetahi pūtau ki reira me te rarangi taka-iho mo te kaiwhakamahi ki te whiriwhiri i tetahi tauira waea (kia A1). Tīpakohia he pūtau ka haere ki te tahua Raraunga – Taki (Raraunga – Whakamana) i roto ranei i nga putanga hou o Excel – kei te ripa Raraunga - Whakamana Raraunga (Raraunga - Whakamana Raraunga). Atu ki te mara Momo Raraunga (Whakaae) Kōwhiri Rārangi, engari hei pūtake tohu to tatou Pukaemi Whakaahua (kaua e wareware ki te taapiri i tetahi tohu rite ki mua):

I tua atu, he pai ki te hoatu i tenei pūtau he ingoa - tahua ano Kōkuhu – Ingoa – Tautapa katahi ka whakauru ingoa (hei tauira kōwhiringa) me te OK.

Hipanga 3: Tāruahia te Whakaahua

Me nukuhia te whakaahua tuatahi mai i te pukaemi whakaahua ki te rarangi taka-iho. Tīpakohia te pūtau me te whakaahua tuatahi (kaua ko te pikitia ake, engari ko te pūtau!) me

i roto i te Excel 2003 me muri mai, purihia te Shift hei whakatuwhera i te tahua Whakatika. Me puta mai he tuemi kaore i kitea i mua. Tārua hei Pikitia:

I roto i te Excel 2007 me te mea hou ake, ka taea e koe te whakawhānui noa i te takaiho i raro i te paatene Tārua (Tārua) on Kāinga ripa:

I roto i te Excel 2010, ka puta ano he matapihi taapiri me te kowhiringa o te ahua o te ahua ka hangaia:

I roto, me whiriwhiri koe i nga whiringa "penei i te mata" me te "raster".

Tārua, haere ki Reta 2 ki te rarangi taka-iho me tetahi pūtau kau e tata ana ki a ia, whakauruhia ta maatau whakaahua-iti o te pūtau me te whakaahua (tahua Whakatika – Whakapiri ranei te tikanga CTRL+V).

Hipanga 4. Waihangahia he hononga hihiri ki te whakaahua kua tohua

Inaianei me hanga e koe he hononga e tohu ana ki te pūtau me te whakaahua kua tohua. Te whakatuwhera i te tahua Kōkuhu – Ingoa – Tautuhia or Kaiwhakahaere Ingoa ripa Ngā tauira me te hanga i tetahi atu awhe ingoa:

Ko te ingoa o to tatou hononga, me kii, ka waiho whakaahua, me te tātai

=СМЕЩ(Лист1!$B$2;ПОИСКПОЗ(Выбор;Фотоальбом;0)-1;0;1;1)

=OFFSET(Лист1!$B$2;MATCH(Выбор;Фотоальбом;0)-1;0;1;1)

Ma te hangarau, he mahi MATCH ka kitea he pūtau me te tauira e hiahiatia ana i roto i te raarangi ingoa, me te mahi OFFSET ka hoatu he hononga ki te pūtau e pātata ana ki te taha matau o te ingoa i kitea, arā, te pūtau me te whakaahua o te hua.

Hipanga 5. Te taapiri i tetahi whakaahua ki tetahi hononga

Ka noho tonu ki te kowhiri i te whakaahua kua kapehia Rarangi 2 ka tomo ki te pae tātai

=whakaahua

a ka pato tomo

Katoa! 🙂

• Waihangahia he rarangi taka-iho ki nga pūtau raumahi 
• Te Waihanga Whakataka Whakaiti 
• Hanga Aunoa i nga Rarangi Whakataka iho me nga Utauta Tāpiri-Mai PLEX 
• Rarangi takaiho me te whakakore aunoa i nga mea kua whakamahia
• Rarangi whakaheke me te taapiri aunoa o nga mea ngaro