ngelixa ndisebenza e- AmaSpredishithi eGoogle Unokufumana amaspredishithi amakhulu apho kuya kufuneka ujongane nezinto ezininzi eziphindiweyo.
Siyabuqonda ubunzima bokujongana nokuphindaphinda kunye nokuba kunokuba nzima kangakanani xa uphawula kwaye ususa amangeniso nganye nganye.
Nangona kunjalo, ngoncedo UkuFomatha ngokuNemiqathango Ukumakisha nokususa iikopi ziphinda kube lula kakhulu.
Ngelixa ukufomatha phantsi kwemiqathango kwenza kube lula kakhulu ukwahlula eziphindiweyo kwi AmaSpredishithi eGoogle.
Landela esi sikhokelo njengoko sikuxelela indlela yokufumana kunye nokususa amangeniso aphindwe kabini kuGoogle AmaSpredishithi.
Konke okufunekayo kukucofa nje okumbini ukususa iikopi kwi-Google AmaSpredishithi kwaye masibazi.
AmaSpredishithi eGoogle: Indlela yokuqaqambisa iikopi eziphindwe kabini kwikholamu enye
ngaphambi kokwazi Ungawasusa njani amangeno aphindwe kabini Ukusuka izipredishithi Uphando Masifunde indlela yokwahlulahlula iikopi kwikholamu enye. Landela la manyathelo.
- Vula ispredishithi kwiiGoogle AmaSpredishithi kwaye ukhethe ikholamu.
- Umzekelo, khetha Uluhlu A > Ukulungelelanisa > Ukulungelelanisa Ipolisa .
- Ngaphantsi kwemithetho yokuFomatha, vula imenyu ehlayo kwaye ukhethe Ifomula yesiqhelo yile .
- Ngenisa ixabiso lefomula yesiqhelo, = ukubala (A1: A, A1)> 1 .
- Ngaphantsi kweMigaqo yokuFomatha, unokufumana iZimbo zeFomathi, ezikuvumela ukuba unike umbala owahlukileyo kwiimpinda eziphindiweyo. Ukwenza oku, cofa kwi icon Gcwalisa umbala Kwaye ukhethe umthunzi wakho owuthandayo.
- Nje ukuba ugqibile, cinezela Zenziwa okanye Yagqitywa Ukuqaqambisa iikopi eziphindwe kabini kwikholamu enye.
- Ngokufanayo, ukuba kuya kufuneka wenze oku kwikholamu C, ifomula iba, = countif (C1: C, C1)> 1 kunye nentando Kuyafana nakwezinye iikholamu.
Ngaphandle koko, kukho indlela yokufumana iikopi eziphakathi kwiikholamu ngokunjalo. Ukufunda, landela la manyathelo.
- Masithi ufuna ukuqaqambisa iikopi eziphindiweyo phakathi kweeseli C5 ukuya kwi-C14.
- Kule meko, yiya ku Ukulungelelanisa kwaye ukhethe ukufomatha ngokuxhomekeka .
- Ngaphantsi kokufaka isicelo kubungakanani, ngenisa uluhlu lweedatha, C5:C14 .
- Okulandelayo, phantsi kwemithetho yokuFomatha, vula imenyu ehlayo kwaye ukhethe Ifomula yesiqhelo yile .
- Ngenisa ixabiso lefomula yesiqhelo, = ukubala (C5: C, C5)> 1 .
- Ukuba unqwenela, nika umbala owahlukileyo kwiimpinda eziphindiweyo ngokulandela amanyathelo angaphambili. Nje ukuba ugqibile, cinezela Yagqitywa .
- Ukuba unqwenela, nika umbala owahlukileyo kwiimpinda eziphindiweyo ngokulandela amanyathelo angaphambili. Nje ukuba ugqibile, cinezela Yagqitywa .
AmaSpredishithi eGoogle: Ungazibona njani iimpinda kwiikholamu ezininzi
Kwimeko apho ufuna ukumakisha iimpinda kwiikholamu ezininzi kunye nakwimiqolo, landela la manyathelo.
- Vula ispredishithi kwiiGoogle AmaSpredishithi kwaye ukhethe iikholamu ezininzi.
- Umzekelo, khetha iikholamu B ukuya ku-E> cofa format > Cofa ukufomatha ngokuxhomekeka .
- Ngaphantsi kwemithetho yokuFomatha, vula imenyu ehlayo kwaye ukhethe Ifomula yesiqhelo yile .
- Ngenisa ixabiso lefomula yesiqhelo, = ukubala (B1: E, B1)> 1 .
- Ukuba unqwenela, nika umbala owahlukileyo kwiimpinda eziphindiweyo ngokulandela amanyathelo angaphambili. Nje ukuba ugqibile, cinezela Yagqitywa .
- Ngokufanayo, ukuba ufuna ukukhankanya ukwenzeka kwikholamu M ukuya ku-P, endaweni ye-B1 ufake u-M1 kunye no-E ngo-P. = ukubala (M1: P, M1)> 1 .
- Ukongeza, ukuba ufuna ukumakisha ukwenzeka kwazo zonke iikholamu ukusuka ku-A kuye ku-Z, phinda nje amanyathelo angaphambili kwaye ufake ixabiso kwifomula yesiqhelo, = ukubala (A1: Z, A1)> 1 .
AmaSpredishithi eGoogle: Susa iimpinda kwi-spreadsheet yakho
Emva kokuba ugqibile ukuqaqambisa ungeniso oluphindwe kabini kwispredishithi, inyathelo elilandelayo kukususa. Landela la manyathelo.
- Khetha ikholamu apho ufuna ukususa iikopi.
- Cofa I-Ekibheli > susa iikopi .
- Ngoku uza kubona i-popup. beka uphawu Kwibhokisi ecaleni kwedatha inentloko ngoku> cofa phinda kabini ususe > Cofa Yagqitywa .
- Unokuphinda amanyathelo ezinye iikholamu.
Le yindlela onokuthi umakishe kwaye ususe abaphindiweyo kwi AmaSpredishithi eGoogle.
