Qonda umsebenzi we-MODE kuma-Google AmaSpredishithi

01 ka 01

Thola Inani Elivame Kangako Kakhulu Nge-MODE Umsebenzi

I-Google AmaSpredishithi ispredishithi esekelwe kuwebhu elidunyiswayo ngenxa yokuthi kulula ukusebenzisa. Ngenxa yokuthi ayibophezelwe kumshini owodwa, ungafinyelelwa kusuka noma yikuphi futhi kunoma yiluphi uhlobo lwedivayisi. Uma ususha ku-Google AmaSpredishithi, kuzodingeka ukwazi imisebenzi eminingana ukuze uqalise. Lesi sihloko sibheka umsebenzi we-MODE, othola inani elivame ukwenzeka kakhulu kwiqoqo lezinombolo.

Isibonelo, inombolo isethwe:

I-1,2,3,1,4

imodi iyinombolo 1 ngoba iyenzeka kabili kuhlu futhi zonke izinombolo zivela kanye kuphela.

Uma izinombolo ezimbili noma ngaphezulu zenzeka ohlwini olufanayo izikhathi eziningi, bobabili babhekwa njengemodi.

Ukuze isethi isethwe:

I-1,2,3,1,2

kokubili izinombolo 1 no-2 zibhekwa njengemodi kusukela kokubili zenzeka kabili ohlwini futhi inombolo 3 ibonakala kanye kuphela. Esikhathini sesibili, isethi yenombolo kuthiwa yi-bimodal.

Ukuthola imodi yeqoqo lezinombolo uma usebenzisa amaSpredishithi e-Google, sebenzisa umsebenzi we-MODE.

Indlela yokusebenzisa umsebenzi weMODE kuma-Google AmaSpredishithi

Vula idokhumenti entsha ye-Google AmaSpredishithi bese ulandela lezi zinyathelo ukuze ufunde ukuthi ungasebenzisa kanjani umsebenzi we-MODE.

1. Faka idatha elandelayo kumaseli A1 kuya ku-A5: igama elithi "eyodwa," namanani 2, 3, 1 no-4 njengoba kuboniswe kumdwebo ohambisana nalesi sihloko.
2. Chofoza ku- cell A6, indawo lapho imiphumela ezoboniswa khona.
3. Thayipha uphawu olulinganayo = olulandelayo igama elithi "imodi ."
4. Njengoba uthayipha, ibhokisi eliphakanyiswa ngokuzenzakalela livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi M.
5. Uma igama elithi "imodi" livela phezulu kwebhokisi, cindezela ukhiye wokungena kwikhibhodi ukungena igama lomsebenzi bese uvula ibhakha nxazonke ( esitokisini A6.
6. Gqamisa amaseli A1 kuya ku-A5 ukuze uwafake njengezingqinamba zomsebenzi.
7. Thayipha ibhakha lokuvala lokuvala ) ukufakazela izingqinamba zomsebenzi.
8. Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi.
9. Iphutha le- # N / A kufanele livele esitokisini se-A6 ngoba akukho namba ebangeni elikhethiwe lamaseli elivela izikhathi ezingaphezu kwesisodwa.
10. Chofoza kwiseli A1 bese uthayipha inombolo 1 ukufaka igama elithi "eyodwa".
11. Cindezela ukhiye wokungena kwikhibhodi
12. Imiphumela yomsebenzi we-MODE ku-cell A6 kufanele iguqule ku-1. Ngoba kukhona manje amaseli amabili ebangeni eliqukethe inombolo 1, imodi yeqoqo elikhethiwe.
13. Uma uchofoza ku-cell A6, umsebenzi ophelele = I-MODE (A1: A5) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela

I-syntax yeMisebenzi ye-MODE ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, abahlukanisi be-comma kanye nezimpikiswano .

I-syntax yomsebenzi we-MODE yi: = MODE (inombolo_1, inombolo_2, ... inombolo_30)

• inombolo_1 - (edingekayo) idatha okufanele ifakwe ekubaleni imodi
• inombolo_2: inombolo_30 - (okukhethwa kukho) amanani wedatha eyengeziwe ukuze afakwe emibhalweni yemodi. Inombolo ephezulu yokufakwayo evunyelwe i-30.

Izinombolo zezinombolo zingaqukatha:

• uhlu lwezinombolo
• amasetferensi weselula endaweni yedatha kushidi lokusebenzela
• ububanzi bezinkomba zocingo
• ibanga elibizwe

Amanothi

• Okufakwayo kombhalo kufakwe kuhlu lwezinombolo zocingo olunganakiwe ngomsebenzi. Uma amaseli aqukethe umbhalo ahlelwa kamuva ukuze abambe izinombolo, imodi ibuyele kabusha, uma kunesidingo, ukuze ihambisane nezinguquko.
• Uma kungekho nhlobo ibonakala ngaphezu kweyodwa ku-data ekhethiwe yedatha, iphutha le- # N / A livela esitokisini lapho umsebenzi ukhona khona.