ngenkathi ngisebenza e- Google AmaSpredishithi Ungahlangabezana namaspredishithi amakhulu lapho kufanele ubhekane nokufakiwe okuningi okuyimpinda.
Siyabuqonda ubunzima bokubhekana nezimpinda nokuthi kungaba nzima kanjani uma uqokomisa futhi ususa okufakiwe ngakunye.
Kodwa-ke, ngosizo Ukufomatha okunemibandela Ukumaka nokususa izimpinda kuba lula kakhulu.
Ngenkathi ukufomatha okunemibandela kwenza kube lula kakhulu ukuhlukanisa izimpinda ku Google AmaSpredishithi.
Landela lo mhlahlandlela njengoba sikutshela ukuthi ungakuthola kanjani futhi ususe okufakiwe okuyimpinda kumaSpredishithi eGoogle.
Konke okudingekayo ukuchofoza okumbalwa ukususa izimpinda ku-Google AmaSpredishithi futhi masizazi.
I-Google AmaSpredishithi: Ungagqamisa kanjani izimpinda kukholamu eyodwa
ngaphambi kokwazi Ungakususa kanjani okufakiwe okuyimpinda Kusuka amaspredishithi -Google Masifunde ukuthi singahlukanisa kanjani izimpinda kukholamu eyodwa. Landela lezi zinyathelo.
- Vula ispredishithi ku-Google AmaSpredishithi bese ukhetha ikholomu.
- Isibonelo, khetha Ikholomu A > Ukudidiyela > Ukudidiyela Iphoyisa .
- Ngaphansi kwemithetho yokuFometha, vula imenyu eyehlayo bese ukhetha Ifomula yangokwezifiso ithi .
- Faka inani lefomula yangokwezifiso, = isibalo (A1: A, A1)> 1 .
- Ngaphansi Kwemithetho Yefomethi, ungathola Izitayela Zefomethi, ezikuvumela ukuthi unikeze umbala ohlukile kuzimpinda ezigqanyisiwe. Ukuze wenze lokhu, thepha isithonjana Gcwalisa umbala Futhi khetha umthunzi wakho owuthandayo.
- Uma usuqedile, cindezela Kwenziwe أو Kwaqedwa Ukugqamisa izimpinda kukholamu eyodwa.
- Ngokufanayo, uma kufanele ukwenze lokhu kukholamu C, ifomula iba, = countif (C1: C, C1)> 1 nentando Okufanayo kuya kwamanye amakholomu.
Ngaphandle kwalokho, kunendlela yokuthola izimpinda phakathi kwamakholomu futhi. Ukuze ufunde, landela lezi zinyathelo.
- Ake sithi ufuna ukugqamisa izimpinda eziphakathi kwamaseli C5 kuye ku-C14.
- Kulokhu, iya ku- Ukudidiyela bese ukhetha ukufometha okunemibandela .
- Ngaphansi kokufaka isicelo esikalini, faka ibanga ledatha, C5:C14 .
- Okulandelayo, ngaphansi kwemithetho yokuFometha, vula imenyu yokudonsela phansi bese ukhetha Ifomula yangokwezifiso ithi .
- Faka inani lefomula yangokwezifiso, = isibalo (C5: C, C5)> 1 .
- Uma ufisa, nikeza umbala ohlukile kuzimpinda ezigqanyisiwe ngokulandela izinyathelo zangaphambilini. Uma usuqedile, cindezela Kwaqedwa .
- Uma ufisa, nikeza umbala ohlukile kuzimpinda ezigqanyisiwe ngokulandela izinyathelo zangaphambilini. Uma usuqedile, cindezela Kwaqedwa .
I-Google AmaSpredishithi: Ungazibona kanjani izimpinda kumakholomu amaningi
Uma nje ufuna ukumaka izimpinda kumakholomu amaningi nasemigqeni, landela lezi zinyathelo.
- Vula ispredishithi ku-Google AmaSpredishithi bese ukhetha amakholomu amaningi.
- Isibonelo, khetha amakholomu B kuye ku-E> chofoza Ifomethi > Chofoza ukufometha okunemibandela .
- Ngaphansi kwemithetho yokuFometha, vula imenyu eyehlayo bese ukhetha Ifomula yangokwezifiso ithi .
- Faka inani lefomula yangokwezifiso, = isibalo (B1: E, B1)> 1 .
- Uma ufisa, nikeza umbala ohlukile kuzimpinda ezigqanyisiwe ngokulandela izinyathelo zangaphambilini. Uma usuqedile, cindezela Kwaqedwa .
- Ngokufanayo, uma ufuna ukucacisa ukuvela kwekholomu M kuye ku-P, ufake i-B1 nge-M1 ne-E nge-P. Ifomula entsha iba, = isibalo (M1: P, M1)> 1 .
- Ngokwengeziwe, uma ufuna ukumaka ukwenzeka kwawo wonke amakholomu kusuka ku-A kuye ku-Z, mane uphinde izinyathelo ezedlule bese ufaka inani lefomula yangokwezifiso, = isibalo (A1: Z, A1)> 1 .
I-Google AmaSpredishithi: Susa izimpinda kusuka kuspredishithi sakho
Ngemuva kokuqeda ukugqamisa okufakiwe okuyimpinda kuspredishithi, isinyathelo esilandelayo ukusisusa. Landela lezi zinyathelo.
- Khetha ikholomu ofuna ukususa kuyo izimpinda.
- Chofoza I-البيانات > susa izimpinda .
- Manje uzobona okuzivelelayo. faka uphawu Ebhokisini eliseduze nedatha unonhlokweni manje> chofoza phinda ususe > Chofoza Kwaqedwa .
- Ungaphinda futhi izinyathelo zamanye amakholomu.
Nakhu ukuthi ungamaka futhi ususe izimpinda ku Google AmaSpredishithi.
