01 ya 01
Zolemba ZONSE ZOKHALA
KUGWIRITSANI NTCHITO ZOCHITA
Ntchito ya MATCH imagwiritsidwa ntchito kubwereza chiwerengero chomwe chimasonyeza malo ofanana pa deta kapena mndandanda wa maselo ambiri. Amagwiritsiridwa ntchito pamene malo a chinthu chomwe chilipo pamtundu wofunikira amafunika m'malo mwa chinthu chomwecho.
Zomwe zafotokozedwa zingakhale zogwiritsira ntchito kapena chiwerengero cha nambala.
Mwachitsanzo, mu chithunzi pamwambapa, ndondomeko yomwe ili ndi MATCH ntchito
= MATCHA (C2, E2: E7,0)
amabwezeretsa malo amodzi a Gizmos monga 5, chifukwa ndilo lolowera lachisanu mu F3 mpaka F8.
Chimodzimodzinso, ngati C1: C3 yochuluka ili ndi nambala monga 5, 10, ndi 15, ndiye njirayo
= MATCHA (15, C1: C3,0)
angabwererenso nambala 3, chifukwa 15 ndilowetsamo katatu.
Kuphatikizana MATCH ndi Ntchito Zina za Excel
Ntchito ya MATCH nthawi zambiri imagwiritsidwa ntchito mogwirizana ndi ntchito zina zowoneka ngati VLOOKUP kapena INDEX ndipo imagwiritsidwa ntchito ngati zowonjezera pazitsulo zina, monga:
- ndemanga ya col_index_num ya VLOOKUP;
- mzere_makangano a INDEX ntchito.
MALANGIZO Ntchito Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.
Chidule cha ntchito MATCH ndi:
= MATCH (Lookup_value, Lookup_array, Match_type)
Lookup_value - (yofunika) mtengo umene mukufuna kupeza mndandanda wa deta. Mtsutso uwu ukhoza kukhala nambala, malemba, mtengo wogwirizana, kapena mawonekedwe a selo .
Kuwona_kusowa - (kofunikira) maselo ambiri akufufuzidwa.
Match_type - (zosankha) amauza Excel momwe angagwirizane ndi Lookup_value ndi mfundo mu Lookup_array. Phindu lokhazikika pazitsutsano izi ndi 1. Zosankha: -1, 0, kapena 1.
- Ngati Match_type = 1 kapena yasiyidwa: MATCH amapeza mtengo waukulu kwambiri kuposa wofanana kapena wofanana ndi Lookup_value. Deta ya Lookup_array iyenera kusankhidwa kukwera.
- Ngati Match_type = 0: MATCH amapeza mtengo woyamba womwe uli wofanana ndi Lookup_value. Deta ya Lookup_array ikhoza kusankhidwa mu dongosolo lililonse.
- Ngati Match_type = -1: MATCH amapeza mtengo wochepa kwambiri kuposa kapena wofanana ndi Lookup_value. Deta ya Lookup_array iyenera kusankhidwa potsika.
Chitsanzo Pogwiritsa ntchito MATCH Ntchito
Chitsanzo ichi chigwiritsa ntchito ntchito MATCH kupeza malo a Gizmos m'ndandanda wazinthu.
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yonse monga = MATCH (C2, E2: E7,0) mu selo lopangira
- Kulowa ntchito ndi ndemanga pogwiritsa ntchito bokosi la zokambirana
Kugwiritsa ntchito BUKHU Logwiritsa Ntchito la MATCH
Mndandanda pansipa tsatanetsatane momwe mungalowetse MCHINYAMATA ntchito ndi ziganizo pogwiritsa ntchito bokosi lachitsanzo cha chitsanzo chomwe chili mu chithunzi pamwambapa.
- Dinani pa selo D2 - malo omwe zotsatira za ntchitoyi zikuwonetsedwa
- Dinani pa Fomu tab ya menyu yowonjezera
- Sankhani Kutsegula ndi Kutchulidwa kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
- Dinani PEZANI MMENE mndandanda kuti mubweretse bokosi lazokambirana
- Mu bokosi la bokosi, dinani pa lookup_value mzere
- Dinani pa selo C2 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
- Dinani pa mzere wa Lookup_array mu bokosi la bokosi
- Onetsetsani maselo E2 ku E7 mu ofesi yolembera kuti mulowetse mndandanda mu bokosi
- Dinani pa Match_type mzere mu bokosi la dialog
- Lowani nambala " 0 " (palibe ndemanga) pamzerewu kuti mupeze mndandanda weniweni ndi deta mu selo D3
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
- Chiwerengero "5" chikuwonekera mu selo D3 kuyambira nthawi yomwe Gizmos ndi chinthu chachisanu kuchokera pamwamba pa mndandanda wazinthu
- Mukasindikiza pa selo D3 ntchito yonse = MATCH (C2, E2: E7,0) amawoneka mu barra ya fomula pamwamba pa tsamba
Kupeza malo a Zolemba Zina
M'malo molowa mu Gizmos monga kukangana kwa Lookup_value , mawuwa alowetsedwa mu selo ndi selo D2 ndipo kenaka kachilombo kaja kamalowetsedwa ngati kutsutsana kwa ntchitoyo.
Njirayi imapangitsa kuti zikhale zophweka kufufuza zinthu zosiyana popanda kusintha fomu yochezera.
Kufufuza chinthu china - monga Gadgets -
- Lowani dzina lachigawo mu selo C2
- Dinani ku key lolowamo pa khibhodi
Chotsatira mu D2 chidzasinthidwa kuti chiwonetsetse malo omwe ali mndandanda wa dzina latsopanolo.