Omunye wemisebenzi ejwayelekile yomsebenzisi we-Microsoft Excel. Sinobubanzi obubili bezinsuku zohlobo "lokuqala-ukuphela". Inselele iwukunquma ukuthi lezi zigaba ziyedlulana, uma kunjalo, zingaki izinsuku.
Uyaphambana noma cha?
Ake siqale ngokuxazulula umbuzo wokuthi kukhona yini ukuphambana kwezikhawu ngokomgomo? Ake sithi sinetafula lamashifu okusebenza kubasebenzi abafana naleli:
Kubonakala ngokucacile ukuthi amashifu omsebenzi we-Yaroslav no-Elena ahlangana, kodwa kanjani ukubala lokhu ngaphandle kokusebenzisa ukwakha isimiso sekhalenda nokulawula okubukwayo? Umsebenzi uzosisiza SUMPRODUCT (SUMPRODUCT).
Masifake enye ikholomu etafuleni lethu ngefomula eveza inani le-boolean TRUE uma amadethi ephambana:
Zingaki izinsuku zokuwela?
Uma ngokuyisisekelo kungelula ukuqonda ukuthi izikhawu zethu ziyaphambana noma cha, kodwa ukwazi kahle ukuthi zingaki izinsuku eziwela ngqo empambanweni yomgwaqo, khona-ke umsebenzi uba nzima kakhulu. Ngokunengqondo, kuyadingeka "ukumpompa" izimo eziningi ezi-3 ngendlela eyodwa:
- izikhawu azidlulelani
- esinye sezikhawu simunca ngokuphelele esinye
- izikhawu ziphambana kancane
Ngezikhathi ezithile, ngibona ukuqaliswa kwale ndlela ngabanye abasebenzisi besebenzisa inqwaba yemisebenzi ye-IF evalelwe, njll.
Eqinisweni, konke kungenziwa kahle ngokusebenzisa umsebenzi UMEDIYA (MEDIAN) kusukela esigabeni Isitatimende.
Uma ngokwemibandela sibeka ukuqala kwesikhawu sokuqala njenge N1, nesiphetho se K1, kanye nesiqalo sesibili N2 futhi uqedele K2, bese ngokwejwayelekile ifomula yethu ingabhalwa kanje:
=MEDIAN(N1;K1+ 1;K2+1)-MEDIAN(N1;K1+ 1;N2)
Compact futhi nenhle, akunjalo? 😉
- I-Excel isebenza kanjani ngempela namadethi? Ungabala kanjani inani lekhalenda noma izinsuku zebhizinisi phakathi kwamadethi?
- Ulakha kanjani uhlelo lwekhalenda (amaholide, ukuqeqeshwa, amashifu…) ku-Excel usebenzisa ukufometha okunemibandela?
- Ihlola isimo esisodwa noma ngaphezulu ngemisebenzi ye-IF (IF).