Ungawathola kanjani amaseli ayimpinda eshidini le-Excel

Omunye wemisebenzi yakudala yokusesha amaphutha noma ukuhlanza ifayela le-Excel ukucinga amaseli ayimpinda.

Kunezindlela ezimbalwa zokuthola amaseli ayimpinda, kulesi sihloko sizobheka izindlela ezimbili ezilula zokuthola nokugqamisa amaseli ayimpinda kuspredishithi se-Excel.

Thola amaseli ayimpinda ku-Excel

Ukubonisa indlela yokuthola amaseli ayimpinda ku-Excel, masisebenzise isipredishithi esilula esingezansi, esinohlu lwamagama kukholamu A.

Ake siqale sibonise indlela yokusebenzisa ukufometha okunemibandela ukuze kugqanyiswe amaseli ayimpinda, bese sibonisa ukuthi kanjani sebenzisa umsebenzi Countif kwe-Excel ukuthola izimpinda.

Gqamisa amaseli ayimpinda usebenzisa ukufometha okunemibandela

Ukuze uthole amaseli ayimpinda anokufometha okunemibandela, landela lezi zinyathelo ezingezansi:

• Khetha ububanzi bamaseli ozowafometha.
• Khetha imenyu yokudonsela phansi Ukufometha Okunemibandela kuthebhu ethi Ikhaya phezulu ebhukwini lakho le-Excel. Ngaphakathi kwale menyu:
  • Khetha inketho Gqamisa imithetho yeseli futhi, kumenyu yesibili evelayo, khetha inketho ethi Amanani okuphindiwe… ;

• I-“Amanani ayimpinda“. Imenyu yokudonsela phansi ohlangothini lwesobunxele lwaleli windi kufanele ibonise inani elithi “Impinda” (nakuba lokhu kungashintshwa ukuze kuboniswe amanani ahlukile kuphela, kunokuphinda).

• Qhafaza OK .

Ukufometha amaseli A2-A11 wesibonelo sespredishithi ngale ndlela kukhiqiza umphumela olandelayo:

Thola izimpinda usebenzisa Countif

Le ndlela izosebenza kuphela uma okuqukethwe kweseli kunezinhlamvu ezingaphansi kuka-256 ngobude, njengoba imisebenzi ye-Excel ingakwazi ukuphatha izintambo zombhalo ezinde.

Ukuze ubonise indlela yokusebenzisa i- umsebenzi Countif Ukuze sithole izimpinda ku-Excel, sizosebenzisa isibonelo sesipredishithi esingenhla, esinohlu lwamagama agcwalisa ikholomu A.

Ukuthola noma yiziphi izimpinda ohlwini lwamagama, sifake umsebenzi Countif kukholamu B yesipredishithi, ukukhombisa inani lezenzeko zegama ngalinye. Njengoba kukhonjisiwe kubha yefomula, umsebenzi Countif esetshenziswa cell B2 kuyinto :=COUNTIF( A:A, A2 )

Lo msebenzi ubala inani lokuvela kwenani kuseli A2 (igama elithi “Adam SMITH”) ngaphakathi kwekholomu A yesipredishithi.

Lapho umsebenzi Countif ikopishelwe kukholomu B yesipredishithi, izobala inani lezenzeko zamagama kumaseli A3, A4, njll.

Ungabona ukuthi umsebenzi Countif ibuyisela inani elingu-1 kumigqa eminingi, okubonisa ukuthi kukhona isenzakalo esisodwa kuphela samagama kumaseli A2, A3, njll. Nokho, uma kuziwa egameni elithi “John ROTH”, (elikhona kumaseli A3 no-A8), umsebenzi ubuyisela inani elingu-2, okubonisa ukuthi kukhona izenzakalo ezimbili zaleli gama.

Ercole Palmeri